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 16:06:53

Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States

10/12/1999 16:01:37

Mark Gattis
Marquis Services, Inc.
Plano, Texas, 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:

00301995

Views:

=SQLEexec(nHandle, "select ContHist.RecID from ContHist where INLIST(ContHist.ResultCode,'EXP','BXP')", "ThisCursor")

What is SQLEExec? is this a VFP6 thing? ODBC thing?

I'm wondering how it's different from SELECT - SQL...
(I almost replied that SQLEXEC isn't even in this language)

Map

View

Click here to load this message in the networking platform