Picking up Variables in SQL Text?

sparkz · November 2006

I have a frxDBXQuery object with SQL text in it. I want to pass the contents of a variable I've created to it (this contains a date).

The variable can be used else where without any problem but when running the report it says the variable doesn't have a value.

I'm using the syntax:
...
COUNT(CASE WHEN DateOpened >= :StartDate THEN 1 END)
...

The variable is set in Delphi with:

frxReport1.Variables := StartDate;

Is this wrong or is it not possible to pass variables in this way?

If not I guess you'd have to set the SQL string in code somewhere. Perhaps when the report starts?

Thanks for any help...

Mark

AlexTZ · November 2006

You should go query.Params editor and set up your parameter. Look at "internal datasets/Internal query" report in the frdemo.

sparkz · November 2006

Thanks!

I didn't spot that in the manual (I'm using the Studio V3 manuals at present) but it was under my nose all along!

Mark

Picking up Variables in SQL Text?

Comments

Leave a Comment