[yunqa.de] DISQLite3 - How to bind parameters with it's names
- From: Gabor Boros <gaborboros@xxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Mon, 28 Jan 2013 11:06:26 +0100
Hi,
I got error message ("SQLite Error 25 - bind or column index out of
range") if try to set parameter values of a statement with
Bind_Variant_By_Name. If I use Bind_Variant everything work like a
charm. I need a trick other than prepare?
var
DB:TDISQLite3Database;
SC:TDISQLite3Statement;
begin
.
.
.
SC:=DB.Prepare('INSERT INTO MYTABLE (ID, FIELD1) VALUES (NULL,
:IN_MYPARAM_1);');
SC.Bind_Variant_By_Name('IN_MYPARAM_1',1); <-- error
Gabor
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
