How about this method: Dim oGeo As Object Fetch First From GEO oGeo = GEO.OBJ Select * From POINTS Where OBJ Within oGeo The problem here is that this code will take the first record in your table GEO. If you need a specific record you should use SQL to select this and then afterwards fetch the object from the selection (or named query): Selection: Select * From GEo Where <some condition> Fetch First From Selection oGeo = Selection.OBJ Named query: Select * From GEo Where <some condition> Into MY_QUERY NoSelect Fetch First From MY_QUERY oGeo = MY_QUERY.OBJ HTH Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 5260 Odense S. Denmark Tel + 45 6311 4900 Dir +45 6311 4908 Mob +45 5156 1045 Fax + 45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk <http://www.cowi.dk/>
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 15-Jun-04 20:37 To: [EMAIL PROTECTED] Subject: MI-L Fetch Issues Can anybody explain how to select one row from a table so that I can create a buffer around that record to do a within calculation with another file. I have tried to use the fetch statement but think I am doing it wrong. Ultimately, I will be taking all records and calculating a distance from one point of the first table to those points in the second table that are within the buffer. Any help would be appreciated. If anybody sends an example...assume the table to pull the single record from is called "geo" and the second table that has the points that fall within is called "points". TIA John --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12204
