Re: [gnome-db] Re: GdaParameter Status/Usage

[Rodrigo Moya <rodrigo gnome-db org>]

On Thu, 2001-12-27 at 10:31, Gonzalo Paniagua Javier wrote:
> On Wed, Dec 26, 2001 at 04:56:09PM +0100, Rodrigo Moya wrote:
> > > Essentially, how should a command be formatted for parameter
> > > substitution?
> > > 
> > I suppose it should be using the "standard" (if there's any) for this.
> > So far, I've seen many times, in different programs, that apps use
> > %var%, but, of course, this may not be good for many DBMS, which may use
> > that character for something else.
> > 
> > So, thoughts on how to do it?
> 
> 	I've seen in COBOL/DB2 and Pro*C/Oracle they use ':' like in:
> 
> 		SELECT field1 FROM tbl1 WHERE field2 = :var1
> 
> 	'var1' is defined in the host language.
> 
yes, I was on crack when I said %..% was used, since I was thinking
about Oracle, which is the DB which I've used the most, and which, as
you say, uses :var.

So, if nobody thinks there can be problems with this :... thing, we'll
go with this one.

Anyway, first of all, we need a simple SQL parser:

http://bugzilla.gnome.org/show_bug.cgi?id=67343

anyone volunteers? :-)

cheers
-- 
Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com>
http://www.gnome-db.org/ - http://www.ximian.com/