🚀 go-pugleaf

OK.  I no longer get the error.  I thought I checked but I missed
"descending".  Oh well.  At least now I can resume playing with the code.

Thanks,
Carl

Ken Mayer [TeamB] wrote:

> 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