Re: [Gambas-user] Prepared statements

2012-03-13 Thread Caveat
> With statements, you use a sign, and replace that with a type The sign in Gambas is the &1, &2, &3...which are replaced by the varying number of params after. OK, as far as I can tell it's not a true prepared statement in that there appears to be no way to reuse it with different params but it

Re: [Gambas-user] Prepared statements

2012-03-13 Thread Mathias Maes
That's not really a prepared statement. With statements, you use a sign, and replace that with a type. This is some java sample code: java.sql.PreparedStatement stmt = connection.prepareStatement( "SELECT * FROM users WHERE USERNAME = ? AND PASSWORD = ?"); stmt.setString(1, usernam

Re: [Gambas-user] Prepared statements

2012-03-13 Thread Caveat
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,

[Gambas-user] Prepared statements

2012-03-13 Thread Mathias Maes
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 Micr