SequeLink parse error - bug ???
Posted on 2006-04-23
Good morning experts,
I got stuck with following problem
Trying to access FileMaker Pro 8 data (Win XP) in order to synch VisualCE 9 PDA application.
The FMPro Adv DataDirect SequeLink 5.4 ODBC driver is installed and DSN defined - test connect with FMPro Application sucessfull.
Setting up for Table export and synchronisation I receive following error
[DataDirect][ODBC SequeLink driver][ODBC Socket][Datadirect][ODBC Filemaker driver][Filemaker] Parse Error in SQL.
The ODBC log shows that this error is raised with following SQL statement
select * from "Clients" where (OID <> 0) and (OID is not NULL)
OID being an empty number field in the 'clients' table that is used for synchronising
Tried to populate all OID fields with 0 (zero) but got the same result
Went through the FileMaker odbc documentation but could not check whether NULL is acceptable for number fields.
As far I know this query is legal but not recognised by the driver ...
Aside of exporting to text or other I cannot find a way to solve this.
any suggestions , replacement drivers ...
Thanks by avance