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

[Gonzalo Paniagua Javier <gonzalo gnome-db org>]

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.