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



Try 'aaaa' instead of just aaaa using the single quotes.  I think its up to
the user to decide whether it is being compared to a character field or
numeric field.   And if the field being compared to is character, then the
user should use single quotes.

SELECT * FROM SOMETABLE WHERE NUMERIC_COLUMN = :field1

Enter field1 value: 5

SELECT * FROM SOMETABLE WHERE CHARACTER_COLUMN = :field1

Enter field1 value: 'blah'

Anyways, just my two bits...

:)

-----Original Message-----
From: gnome-db-list-admin gnome org
[mailto:gnome-db-list-admin gnome org]On Behalf Of Vivien Malerba
Sent: Friday, January 17, 2003 4:00 PM
To: Rodrigo Moya
Cc: gnome-db-list gnome org
Subject: Re: [gnome-db] input values in SQL view


On Tue, Jan 14, 2003 at 10:53:33PM +0100, Rodrigo Moya wrote:
> Hi
>
> I've just implemented support for input values in the SQL window, so now
> you can do things like:
>
> update table set field1 = :field1, field2 = ':field2'
>
> and mergeant will ask you for :field1 and :field2 values.

Nice feature!

>
> 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.

Cheers,

Vivien

_______________________________________________
gnome-db-list mailing list
gnome-db-list gnome org
http://mail.gnome.org/mailman/listinfo/gnome-db-list




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]