Listers,
Is it possible to use a string variable in a select statement?
The following bit of code doesn't seem to work:
Select Wells.Owner, Wells.Owner_Abbr, Wells.Owner_Well_No, YearField_str
from Wells, Production where
Wells.Primary_Key=Production.Primary_Key and YearField_str>0 into Selection
The YearField_str value has the form Production._19xx, with the actual year
value obtained from a dialog box where the user types in the year they want
to query.
TIA
_____________________________
Tim Warman
Geologist & GIS Specialist
Richard C. Slade & Associates
North Hollywood, CA
(818) 506-0418
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]