[Gambas-user] Prepared statements
Caveat
Gambas at ...1950...
Tue Mar 13 09:29:20 CET 2012
You mean like this (not so long ago on this very mailing list...)
> Caveat wrote:
> >
> > Here's some working code...
> >
> > conn = DataAccess.getConnection()
> > conn.Exec("delete from UTI001 where CLEF = &1", "Caveat")
> > conn.Exec("insert into UTI001 (CLEF, Langue, Backup) VALUES (&1,
&2, &3)", "Caveat", "EN", "C:\\Temp")
> > rSet = conn.Exec("select * from UTI001 where CLEF = &1", "Caveat")
> > If rSet Not Null Then
> > If rSet.Count > 0 Then
> > rSet.MoveFirst
> > Print rSet["CLEF"], rSet["Langue"]
> > Endif
> > Endif
> >
> > As expected, it prints:
> >
> > Caveat EN
> >
> > Regards,
> > Caveat
Regards,
Caveat
On Tue, 2012-03-13 at 09:01 +0100, Mathias Maes wrote:
> Hello,
>
> Are there prepared statements in Gambas? It is so much safer to deal with a
> database with them!
>
> Thanks
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
More information about the User
mailing list