[yunqa.de] Re: DISQLite3 - How to bind parameters with it's names

  • From: Tobias Rapp <t.rapp@xxxxxxxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Mon, 28 Jan 2013 15:03:43 +0100

Gabor Boros wrote:
> SC:=DB.Prepare('INSERT INTO MYTABLE (ID, FIELD1) VALUES (NULL, 
> :IN_MYPARAM_1);');
> 
> SC.Bind_Variant_By_Name('IN_MYPARAM_1',1); <-- error

Try:

SC.Bind_Variant_By_Name(':IN_MYPARAM_1',1);

I have run into this SQLite oddity more than once.

Regards,
Tobias

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



Other related posts: