What is wrong with this SQL?

Discussion in 'Questions (Windows Mobile)' started by RB Smissaert, Dec 12, 2008.

  1. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    Running this on the desktop with all the latest SQLite files:

    SELECT
    E.ADDED_DATE, E.TERM_TEXT, EA.NUMERIC_VALUE
    FROM
    ENTRY E INNER JOIN ENTRY_ATTRIBUTE EA ON
    (E.ENTRY_ID = EA.ENTRY_ID) WHERE
    E.PATIENT_ID = 100 AND E.SUBJECT_TYPE = 'L '

    With the code:
    cmd.ExecuteTable("Table1", 0)

    and get the following error:

    An error occurred on sub main.runsql.
    Line number: 1147
    cmd.ExecuteTable("Table1", 0)
    Error description:
    SQLite error
    near "(": syntax error

    The SQL is fine and I can run it fine in other applications.
    Also the Basic4ppc code is fine as well as other queries run fine.
    Maybe the the SQLite file doesn't like the inner join and that would be real
    nuisance.
    Any ideas what the problem is here?

    RBS
     
  2. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    Sorry, just ignore this.
    It was something entirely different and all fine.

    RBS
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice