SQL syntax problems w/ OLEDB provider? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL syntax problems w/ OLEDB provider?

Message

De

27/04/2004 09:21:46

Neil Gorin
Brooklyn, New York, États-Unis

À

27/04/2004 09:03:16

Cetin Basoz
Engineerica Inc.
Izmir, Turquie

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: SQL syntax problems w/ OLEDB provider?

Divers

Thread ID:

00898465

Message ID:

00898487

Vues:

16

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