home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!noc.near.net!hri.com!spool.mu.edu!darwin.sura.net!jvnc.net!newsserver.jvnc.net!newsserver.technet.sg!ntuix!ntuix!franks
- From: franks@ntrc27.ntrc.ntu.ac.sg (Frank Siebenlist)
- Newsgroups: comp.databases.ingres
- Subject: problem with "DESC" as column name in Windows4GL
- Message-ID: <FRANKS.93Jan8155235@ntrc27.ntrc.ntu.ac.sg>
- Date: 8 Jan 93 07:52:35 GMT
- Sender: news@ntuix.ntu.ac.sg (USENET News System)
- Distribution: comp
- Organization: /home/franks/.organization
- Lines: 50
- Nntp-Posting-Host: ntrc27.ntrc.ntu.ac.sg
-
-
- If a column name of "DESC" is used,
- then it seems "difficult" to access that column within Windows4GL.
-
- For example a script containing:
-
- select :my_field = desc
- from my_table;
-
- yields compilation errors like:
-
- E_W40118 The symbol 'desc' is undefined.
-
- E_PW0005 Can't create variable for desc.
- A variable couldn't be declared for the ENTRYFIELD desc. A subsequent
- error should give more information about why it couldn't be created.
-
- E_SY0010 Reserved word used as name.
- A variable (or other kind of object) was given the name `desc' which is
- a reserved word. You can not use a reserved word to name an object.
-
- This is too bad, but it becomes worse if:
-
- :my_field = my_table.desc
-
- yields the same error.
-
- As far as I know, DESC is not a reserved word for column names.
- Also, other ingres programs like isql have no problem with:
- select desc from my_table;
-
- Is Windows4GL too restrictive? Is this a feature or bug?
-
- Is there a workaround?
-
- Please don't tell me to rename my column names!
- (They are predefined by other existing applications.)
-
- Regards, Frank.
-
- --
- ---------------------------------------------------
- Frank Siebenlist <franks@ntu.ac.sg>
- Senior Research Fellow
- GINTIC Institute of Manufacturing Technology (GIMT)
- Nanyang Technological University (NTU)
- Nanyang Avenue
- Singapore 2263
- Tel: (65) 799-1356 Fax: (65) 791-2927
- ---------------------------------------------------
-