🚀 go-pugleaf

Thanks Mark. My main question is if I don't prepare it, can the SQL
still use parameters?

I guess my problem is I would like to avoid the round-trip to the
server for queries that are executed only once, with or without
parameters. If I have to create the parameters myself, that's fine.
But can I still use parameters, and will the VCL create them for me,
if the query is not prepared?

i.e.

TADOQuery *q= new TADOQuery(0);
q->Connection = TheConnection;
q->Close();
q->SQL->Clear();
q->SQL->Add("SELECT * FROM LAB_ORDER_DTLS WHERE LO_ID = :LO_ID");
q->Parameters->ParamByName("LO_ID")->Value = 10;
q->Open();

Or do I need to place a "q->Prepared = true" just before
ParamByName()?

Thanks again!

Matt



--

My reply-to address is purposely mangled to thwart auto-reply bots. 
Please remove the two leading underscores if you wish to reply via
e-mail.