> 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]