[yunqa.de] Re: TDISQLite3Statement.Sql16 shows "?" instead of bound arguments

  • From: spamrbt <spamme@xxxxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Sun, 28 Oct 2007 15:52:00 +0200



I am not sure if it is an option for you not to host parameters and rewrite 
your queries accordingly. This would of course eliminate the benefits of host 
parameters:

  SELECT id FROM instances WHERE name='John';

Another alternative if your host parameter SQL is application generated 
(instead of user generated): Drop sqlite3_trace and log the SQL and parameter 
values manually when you prepare and bind your SQL statements.
Ralf
I've weighted both these possibilities, and I will have to use one of them, if there is absolutely NO possibility to acquire the values of host parameters from the TDISQLite3Statement (or TDISQLite3Database). It is really strange to me that I could not find a way to acquire these values. 

Aleksandr.

_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa

Other related posts:

  1. Home
  2. yunqa
  3. Archive
  4. 10-2007