OID field causes problems?

[fde101]

When trying to access FileMaker Pro 7 via ODBC, I am using a third party product (a canned solution) which references a field called "OID" in any table I try to access; I have such a field in my tables in FileMaker Pro, but when an SQL query references that field, it generates an error message to the effect of "Parse Error in SQL".

For example, in one table, there are numeric fields called "jobID" and "OID". The query:

select * from HVACs where (jobID <> 0)

works perfectly; however, the query:

select * from HVACs where (OID <> 0)

results in a dialog box with the "Parse Error in SQL" message (and fails).

I must be able to run a query which references an OID field. Is anyone else familiar with this problem? Can anyone verify that this is a problem with FMP7 or the ODBC driver, and not with my configuration or database?

I'd appreciate any help I can get.

Thank you.

[Cato Paus]

Jupp i got the same problem, the problem is in ODBC SequeLink driver 5.4 ! i'm waiting for respons from filemaker

[neonic]

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

Edited August 8, 2005 by Guest

[jkovar]

I am assuming you are using VisualCE since I am familiar with the OID field. I am trying the same thing. Have you gotten an anser yet?

I would sure hate to have to swith to Alpha5!! - lol

By the way, VisualCE syncs fine with Alpha5 tables.