Reportmaker error

[akalehzan]

Hi all,

We are getting error to run the following query from Servoy Reportmaker 1.0RC1:

SELECT id.age_at_acquisition, id.id_diagnosis
FROM id
WHERE id.age_at_acquisition <= 12
AND id.id_diagnosis = "turner syndrome"

Error:
Bad query: java.sql.sqlEXception:[Microsoft][SQLServer 2000 driver for JDBC][SQLSErver}Invalid column name 'turner syndrome'


I ran the same query in Microsoft Access without any error:

SELECT dbo_ID.age_at_acquisition, dbo_ID.ID_DIAGNOSIS
FROM dbo_ID
WHERE (((dbo_ID.age_at_acquisition)<=12) AND ((dbo_ID.ID_DIAGNOSIS)="turner syndrome"));

Please advice,

Thanks,

Abrahim

[bcusick]

Hi Abrahim,

FYI: ReportMaker is not a product of Servoy - it's an EXAMPLE FILE that I came up with to demonstrate what was possible in Servoy - thus, it's an unsupported project. Also, it's fully open, so you can also debug stuff as well.

Having said that - the table in your access example is called "dbo_id" and the one in your example is "id". IT IS A BAD IDEA to name your table with a reserved SQL word "id". Also - you need SINGLE QUOTES not DOUBLE QUOTES in your query for quoted literals.

Try changing your query to:

Code: Select all

SELECT age_at_acquisition, id_diagnosis
FROM id
WHERE age_at_acquisition <= 12
AND id_diagnosis = 'turner syndrome'

Hope this helps.