> Try opening the table using the 'manual' Open ODBC Table menu 
> option. Save
> the table, open the .tab in a text editor and look for any differences
> between the syntax in this and that in your MapBasic 
> statement. This may
> give you a clue?

It did. The TAB files had:

"select ""REAL_SMA_CODE"", ""OBJECT"" from ""STATS"".""HAIL_DETAIL"""

The STATS was the difference. Without the STATS, it didn't work.

Thanks for the help.

jody
--------------------------
Jody Cairns
[EMAIL PROTECTED], or
[EMAIL PROTECTED] 
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to