I cannot seem to do a SQL Select with a where clause

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

I cannot seem to do a SQL Select with a where clause

Message

From

10/12/1999 21:52:10

Donald Hunt
Computerese
Fitchburg, Massachusetts, United States

10/12/1999 21:40:27

Donald Hunt
Computerese
Fitchburg, Massachusetts, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: I cannot seem to do a SQL Select with a where clause

Miscellaneous

Thread ID:

00301982

Message ID:

00302158

Views:

>>>=SQLEexec(nHandle, "select ContHist.RecID from ContHist where INLIST(ContHist.ResultCode,'EXP','BXP')", "ThisCursor")
>
>Letcha know in a couple of minutes.

...and the answer is, no that doesn't work. The returned value is -1. No error message or anything.

Any other suggestions?

DJ

Map

View

Click here to load this message in the networking platform