SQL

[ribbons]

Hi

I have CR XI pulling against an Access database.

Can anyone tell me what the syntax for SQL is in CR XI?

I have tried single quotes, as in CR X, but I get an error message.

SELECT 'TestName' FROM 'Germreadings' Where 'Testname' = "Germination"

I have also tried using the formula editor

 SELECT `GermReadings`.`testname` FROM `Germreadings` WHERE `GermReadings`.`TestName` = 'Germination'

I get with both an error message:

 Error in compiling expression.  Syntax error in query expression

Anyone know what this means?

ribbons

 

[lbass]

Are you trying to do this in the SQL expression area? You should instead be using the syntax in your second code sample in the database->your datasource->add command area.

-LB

 

[ribbons]

That worked great! thanks!