How can I keep adding these to my result?

If I keep calling Select from within a loop,
Does a select overwrite the previous select in a loop?


mike

-----Original Message-----
From: Leyne, Sean [mailto:InterbaseSupport@...]
Sent: Monday, August 27, 2001 2:51 PM
To: 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] For Loop


Mike,

> I tested a query like this and there was no speed degredation.
>
> SELECT * FROM EXPERIAN WHERE
> (LATITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx')
> OR
> (LATITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx')
> AND
> (LONGITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx'
> OR
> (LONGITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx')

If the query gave you the correct results, what's wrong with using that
approach?

Don't quite understand...


Sean

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get VeriSign's FREE GUIDE: "Securing Your Web Site for Business." Learn about using SSL for serious online security. Click Here!
http://us.click.yahoo.com/KYe3qC/I56CAA/yigFAA/dpFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/