SQL syntax problems w/ OLEDB provider? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL syntax problems w/ OLEDB provider?

Message

From

27/04/2004 09:21:46

Neil Gorin
Brooklyn, New York, United States

To

27/04/2004 09:03:16

Cetin Basoz
Engineerica Inc.
Izmir, Turkey

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: SQL syntax problems w/ OLEDB provider?

Miscellaneous

Thread ID:

00898465

Message ID:

00898487

Views:

15

Cetin,

I got it. This is what I did:

xStartTime = "04//25/04 07:00"
xEndTime   = "04/25/04 17:00"


mySQL =  "SELECT * from meetings WHERE StartTime BETWEEN "+;
 "ctot('" + xStartTime + "') and ctot('" + xEndTime + "')"
rs=oConnection.Execute(mySQL)
? rs.GetString()
oConnection.Close
release oConnection

Neil
Thanx ever so much once again

Click here to load this message in the networking platform