Using SQLEXEC with ACCESS and blank dates ??? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Using SQLEXEC with ACCESS and blank dates ???

Message

From

30/01/2004 16:18:10

Luis Perez
Millennium Data Solutions
Coconut Creek, Florida, United States

To

30/01/2004 16:10:23

Fred Taylor
Phoenix, Arizona, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Using SQLEXEC with ACCESS and blank dates ???

Miscellaneous

Thread ID:

00872515

Message ID:

00872536

Views:

25

I got it:

a=SQLEXEC(cnHandle,"INSERT INTO MyTable (DateOfBirth) VALUES(" + Null + ")")

That did it.

thanks Fred !!!!! your comments made me think ! :-)

____________________________
Luis Perez
Millennium Data Solutions, Corp.
President & CEO
e-mail: luis@mds-corp.com
http://www.mds-corp.com
USA
____________________________

Click here to load this message in the networking platform