Re: [gnome-db] parameters in SQL commands

[Rodrigo Moya <rodrigo gnome-db org>]

On Mon, 2002-09-30 at 15:16, Gonzalo Paniagua Javier wrote:
> > 
> > So, the only question is what format to use for the placeholders. I
> > think it is not very important, since the string will be parsed before
> > being sent to the DBMS, but anyway, we should be sure we use something
> > that doesn't conflict with some SQL dialects or whatever.
> > 
> > Ideas? If nobody disagrees, I'll use :name.
> 
> But... what we should support are prepared statements.
> 
> For the providers that don't support them, we can simulate it (ie, we
> generate the whole SQL statement from the parameters and the place
> holders).
> 
> For the rest, we should use whatever the DB backend uses for prepared
> statements and use its native interface. Why? Performance.
> 
do you mean just convert libgda placeholders to the DBMS specific
placeholders and use a PREPARE on it directly on the DBMS server?

cheers