SequeLink parse error - bug ???

Posted on 2006-04-23
Last Modified: 2008-01-09
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
Question by:homeredunord
    LVL 28

    Expert Comment

    the query effectiveley looks ok, but the "null" concept in fmaker is somehow vague.
    I would use >0 since if the field is empty, it won't take as > 0 anyway.

    Author Comment

    Hi Mr Lesouef,
    Thanks for Your answer and suggestion though IOD could receive at a
    later stage a negative integer value and should therefore be retrieved
    even though its value is not >0.
    Since FileMaker Pro does not distinguish numerical and boolean field types
    but would You know if  FileMaker Pro + SequeLink driver react adequately to boolean queries:
    (IOD <> 0) AND (IOD is Not NULL)  is then logically equivalent to IOD is TRUE .

    If this is accepted by FMPro+ driver

    how should the SQL statement be written then
    SELECT * from 'clients' WHERE IOD = TRUE  
    SELECT * from 'clients' WHERE IOD is TRUE

    Thanks by advance,
    LVL 28

    Accepted Solution

    internally, fm is able to identify a null field with the simple logic test "IS", and the answer is 0/1 or true/false depending on text/numeric field type used to store the answer (calculation type).
    how is that translated by the odbc driver, no idea since I am always using fm a ODBC client.
    so, I would guess 'is true' is correct.
    but the area is hairy! I also use servoy with sybase anywhere and I have the same problems, for instance:
    a field in a new blank record would answer correctly to a null test. if I put a value in it, then delete it, it won't be null anymore, but empty!
    so I found out it is safer to test for empty fields where querying a foreign database:
    in yr case that would be:
    SELECT * from clients WHERE IOD <> ''


    Author Comment

    Thanks for the explanation: I think this wraps it up.
    I will conduct a series of tests and act upon the results.
    By the way I just started to use Servoy and am very favorably impressed by the posibilities this development environment offers.
    Thanks a lot for Your help, in absence of additional suggestions I will close this question in a few days.
    LVL 28

    Expert Comment

    servoy is very nice on user interface control.
    I regret the lack of numerous plug-ins so far, and I am still 3 times slower to design things compared to fm.
    but its remote usage through public lines is "wunderbar" compared to a poor web companion ergonomy.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now