Petr,
I do understand only right now that _you_ wrote minigui sqlite interface! :)
I think that we could restrict what is accepted by this new bind_all()
function.
In particular we could say that it works only for the :some_var type of
place-holder.
But, :some_var could be a problem because it is the way in which you reference
a method property inside a with object clause.
So, maybe, we could end up with a different prefix which is then translated in
the .c low level interface.
I mean
with object oObj
...
text into cSql
select * from mytable where key = :some_var
enddtext
...
end
I'm not sure, but I think it will cause some problem since :some_var is a
reference to an iVar of oObj.
Best regards.
Maurilio.
Petr Chornyj ha scritto:
>
> 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
--
__________
| | | |__| Maurilio Longo
|_|_|_|____| farmaconsult s.r.l.
_______________________________________________
Harbour mailing list
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
