dBASE Questions and Answers - LookupSQL on non-numeric key

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

LookupSQL on non-numeric key

Pieter van Heerden

2006-12-03, 12:17 am

LookupSQL does not allow lookups on non-numeric primary key fields. Any way to bypass this problem except adding an autoincrement field as primary key field?

In this particular case it is a list of countries with the primary key field being the ISO 3-letter code for the countries.

Pieter van Heerden

2006-12-04, 12:14 am

Sorry folks, blind stupidity on this side, I forgot about the comma between field names!

Pieter van Heerden Wrote:

> LookupSQL does not allow lookups on non-numeric primary key fields. Any way to bypass this problem except adding an autoincrement field as primary key field?
>
> In this particular case it is a list of countries with the primary key field being the ISO 3-letter code for the countries.
>

Sponsored Links