Article View: borland.public.vdbase.data.sql
Article #1400Reserved word 'current'
From: Dennis Hill
Date: Wed, 21 Jan 1998 00:00
Date: Wed, 21 Jan 1998 00:00
18 lines
911 bytes
911 bytes
I've just hit another problem converting 5.5 to 7.. 1 of the fields in my customer table is named 'current' and stores current balance owed. I now want to construct an sql statement as follows.. select * from customer where current > 0 But this gives incorrect use of keyword error! My question is does anybody know how I can get round this without renaming the field. I don't want to do that because it means searchin for and changing the references to the fieldname in all my related prg's and procedures. -- Regards Den
Technical Details
Message-ID:
<34c62deb.5946943@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,7fc00d6f4da42e49,start X-Google-Attributes: gidff5a1,public From: Dennis_Hill@compuserve.com (Dennis Hill) Subject: Reserved word 'current' Date: 1998/01/21 Message-ID: <34c62deb.5946943@forums.borland.com> X-Deja-AN: 318052400 Organization: None Newsgroups: borland.public.vdbase.data.sql