Maurilio Longo wrote:
>
>
> I think it would be better, if possible, to have a single call to which we
> pass all the variables needed for a query and which does the binding,
> something like
>
> text into csql
> insert into t1( name, age) values( :name, :age )
> endtext
>
> (here the colon as prefix could conflict with an interpreted with object
> qualifier)
>
> and then
>
> sqlite3_bind_all( stmt, 'Mary', 19 [, ...] )
>
>
>
I thinks it is possible, but not very easy to realisation :)
because a next expression also are valid for SQLITE
insert into t1( name, age) values( :name, ?7 )
stmt := sqlite3_prepare( db, "INSERT INTO t1( name, age ) VALUES( :name, ?7
)")
IF ! Empty( stmt )
IF sqlite3_bind_text( stmt, 1, "Andy" ) == SQLITE_OK .AND. ;
sqlite3_bind_int( stmt, 7 /*!!!*/, 17 ) == SQLITE_OK
Regards,
Petr
--
View this message in context:
http://www.nabble.com/Re%3AExperiences-with-sqlite--tp14791570p14799521.html
Sent from the Harbour - Dev mailing list archive at Nabble.com.
_______________________________________________
Harbour mailing list
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
