Re: Lookup Tables

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

Article #627

Back to borland.public.vdbase.data.sql Previous Next

#627

From: Ken Mayer [TeamB]
Date: Wed, 23 Sep 1998 00:00

22 lines
1287 bytes

Carl White <whitecw@earthlink.net> wrote:

>In VdB5 I used the LOOKUP() function.  I gather that instead of this
>function in VdB7 I should be able to use the lookupSQL.  But after
>studying and experimenting with the documentation and example in the
>help file language reference, I'm stumped.
>
>I'm using the following code in the Combobox ONCHANGE event:
>        select desc, type FROM typetbl
>but I get a database engine error: Invalid use of keyword desc,

This is a SQL error -- DESC is a reserved word (short for
"descending"). Don't name a field "DESC". In Visual dBASE 7 tables,
you can actually name the field "description" and get away with it ...


Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Technical Details

Message-ID: <36085951.10883288@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <36085545.4B537BC6@earthlink.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4b901113c5db6356
X-Google-Attributes: gidff5a1,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: Lookup Tables
Date: 1998/09/23
Message-ID: <36085951.10883288@forums.borland.com>
X-Deja-AN: 393855191
References: <36085545.4B537BC6@earthlink.net>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message