🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1400

Reserved word 'current'

#1400
From: Dennis Hill
Date: Wed, 21 Jan 1998 00:00
18 lines
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-mail

Show 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