Re: [gnome-db] input values in SQL view

[Rodrigo Moya <rodrigo gnome-db org>]

On Fri, 2003-01-17 at 21:59, Vivien Malerba wrote:
> > 
> > It works for me so far, but haven't really done a lot of testing, so
> > please tell me any problems you might find.
> > 
> 
> If you try "select * from customers where name = :field1", and enter
> "aaa" for example, it will give you an error: "ERROR:  Attribute 'aaaaa'
> not found" which is not what it's supposed to do.
> 
it doesn't understand data types. It just replaces :whatever with the
string you enter in the dialog, nothing else. So, you have to either
use:

select * from customers where name = ':field1'

or enter 'value' on the dialog.

cheers