Hi Fran,
Not sure what you are after - if it is the SQL syntax used by
Mapinfo/MapBasic try this:
1. Create an ODBC SQL link to a database using MapInfo (menu = File>Open
ODBC table)
2. Save the table
3. Open the newly created .tab file in notepad or other text editor
The table definition includes a Query statement - this is in effect the SQL
eg.
"\DATALINK\Query" = "select `DataSet_ID`, `Dataset_name`,
`Dataset_creation_date`, `Dataset_author`, `Dataset_owner` from
`C:\Userdata\mat\Database\MAT`.`TblDataSets` where (`DataSet_ID` = 15) and
(`Dataset_name` like 'test')"
Similarly, if you create an SQL query of a table using Mapinfo (menu =
Query>SQL select) and save the workspace, you can view the workspace file in
a text editor to see the select statement.
However, I suspect that you are trying to find out the syntax to be used in
the MapInfo Query>SQL select dialogue (to avoid the dreaded errors that you
get when you try to verify your syntax!), and the only method I have found
is trial and error or looking at one that worked previously!
Regards,
Pete, Ordnance Survey, UK
-----Original Message-----
From: Fran Peck [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2000 17:58
To: Mapinfo List (E-mail)
Subject: MI SQL question
Is there reference material that gives a better explanation of SQL select in
MI than the reference and user's guides that come with it? The reference
guide lacks what should be simple things such as the use of like statements,
wildcards, etc. Since every sql handles these statements slightly
differently, it would be good to have a reference to the use. Thanks in
advance.
Fran Peck
Peoria Unified School District
6330 W Thunderbird Rd
Glendale, AZ 85306
Voice: 623-486-6099
Fax: 623-486-6111
Email: [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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
