I'm new to databases and even newer to FMP...I have googled for the
asnwer to my problem but to little success.

I work with an application that queries an Access database, so that is
what i'm used to.

However, we have new clients who wish to use the application with their
existing FMP database.

I'm using FMP 7 and I've got a copy of one of their FMP databases and
have set up an ODBC connection to it using DataDirect 32-bit SequeLink
5.4, it seems to work if i hit 'Test Connect' i get a succesful
connection.

I can connect to it from the application but if i try to run any SQL on
it, even the simplest 'select' statement i just get 'Parse error in SQL'

The name of the table and field names i am using in the statement is from
information found at File - Define - Database


Ok so these are my questions

1. Am i using the correct driver, it seems to connect so i assume i am
2. The SQL i know is for Access, can these be used in FMP or do i need to
modify them, is there anywhere i can find out what the FMP syntax is?
3. The names of table and fieldnames found by File - Define - Database
Is this the correct way of establishing the design of the table
4. Any ideas what could cause 'Parse error in SQL'?


Best wishes and TIA

I hate MS* programs!!!

After many tries and many hours I discovered that the error comes if you
have specified strange names (for Access) for the fields in FileMaker.

I have a database with a field called "FLAG 2"; well, it seems that Access
doesn't allow spaces in field names (at least importing from data from
FileMaker with ODBC). I had your same error: "Parse error in SQL".

I changed the field name in FileMaker (FLAG 2 became FLAG2 without space)
and it worked!!!

Thank you Bill, you are always in our thoughts!!!

In article
<85134e2a201cf5f207a4bc4d8b9f096d (AT) localhost (DOT) talkaboutdatabases.com>,
postmaster (AT) grupotosbano (DOT) it says...
Ah. Those field name constaints are actually pretty common in database
systems. Its generally a good idea to follow them as much as possible
even in filemaker to facilitate future attempts to bridge to other
systems.