🚀 go-pugleaf

Thanks Mark,

The first method works fine for me.

Although I did try your second method, and it didn't seem to work. 
Is there something special that changes in the SQL Query?

i.e.
C++ Code
DynamicFlexSQLStmt = "SELECT :Var1, :Var2 ";
DynamicFlexSQLStmt += "FROM mySQLTable ";
DynamicFlexSQLStmt += "WHERE Date >= :StartDate ";
DynamicFlexSQLStmt += "AND Date <= :EndDate ";

TADOQuery1->Parameters->ParseSQL(DynamicFlexSQLStmt, true);
TADOQuery1->Parameters->ParamByName("Var1")->Value = "Date";
etc...

Debugging the DynamicFlexSQLStmt 
DynamicFlexSQLStmt = "SELECT ?, ? FROM mySQLTable WHERE Date >= ? AND Date <= ?"
It starts when the ParseSQL statement command is executed,
and remains that way after all the ParamByName statements are called

I get an error "No Value given for one or more required Parameters"

Any thoughts?
And THANKS A LOT for the your reply!
You've helped a whole heaps load!

Heinz.



"Mark Guerrieri" <markg11@comcast.net> wrote:
>>
>> AnsiString DynamicFlexSQLStmt = "SELECT Date " + ""... (Whatever I add for
>Column Selections)
>>
>> I cannont use TADOQuery1->SQL->Add(":MyFlexibleSQLStmt");
>> TADOQuery1->SQL->Parameters->ParamByName("MyFlexibleSQLStmt")->Value =
>DynamicFlexSQLStmt;
>>
>
>Try this-
>
>AnsiString DynamicFlexSQLStmt = "SELECT Date " + ""... (Whatever I add for
>Column Selections)
>TADOQuery1->SQL->Text = DynamicFlexSQLStmt;
>
>I do this all the time and it works fine.  I don't bother with parameters,
>I just build the values right into the SQL statement.  If you need
>parameters, add this:
>
>TADOQuery1->Parameters->ParseSQL(DynamicFlexSQLStmt, true);
>TADOQuery1->Parameters->ParamByName("ParamName")->Value = ParamValue;
>
>Mark
>
>