Re: Why does this not work? (keyword 'TEXT')

On Wed, Apr 10, 2002 at 03:55:33PM +0200, Johann Zuschlag wrote:
> And what do you thing about that one:
>
> DEBUG:  query: declare SQL_CUR01F61ED0 cursor for SELECT t29.* FROM STUECKLI  t29 WHERE t29.artikelnum = '010001' AND
t29.artIS NULL  
> ORDER BY t29.artikelnum ASC, t29.art ASC, t29.Position ASC, t29.stueckarti ASC, t29.stckid ASC
> ERROR:  No such attribute or function 'position'
>
> position is not anymore a keyword, IIRC.
> Usually I just patch the ODBC-driver and it works for me.

Let me guess, you have capitals in your field names. When you create the
table, *don't* put quotes around the field names. Then everything becomes
case insenstive.

HTH,
--
Martijn van Oosterhout <kleptog@svana.org>   http://svana.org/kleptog/
> Ignorance continues to thrive when intelligent people choose to do
> nothing.  Speaking out against censorship and ignorance is the imperative
> of all intelligent people.