🚀 go-pugleaf

Ah yes, I missed that- the column and table names can not be parameters- you
need to dynamically add them to your SQL string.

Mark

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:40bd7880@newsgroups.borland.com...
> SELECT ?, ?
>
> Most (if not all) DBMS will not allow parameters at this place. Enclose
also
> column names into quotes - Date is probably keyword. Use TADODataSet and
set
> CommandText property.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Heinz Ketchup" <heinz_like_the_ketchup@h0tmail.no_spam.c0m.no_spam>
> �������/�������� � �������� ���������:
> news:40bb4d03$1@newsgroups.borland.com...
> >
> > 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
> > >
> > >
> >
>
>