What is wrong with this SQL?

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
 
Top