> the biggest reasons to always use ParamByName instead of building SQL
> strings IMO.
I note this statement has been presented a few times in this
discussion. I will say that building SQL strings and using ParamByName
are not mutually exclusive.
With TIBQuery.Create(Nil) do
Try
TIBDatabase := MyIBDatabase;
SQL.Add('SELECT * from MyTable');
SQL.Add('WHERE MyTable.thisDate = :dToday)');
ParamByName('dToday').AsDate := dMyDate;
...
Finally
Free;
end;
Steve
--
Steve Peacocke
http://stevepeacocke.blogspot.com/
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
