SQL Pass through and Access... 1

[Neil Toulouse]

Hi there!

I am trying to insert data into an Access table from Visual FoxPro via ODBC.

I need to insert a blank date.

I insert a date with:

SQLEXEC( lnHandle, "INSERT INTO MyTable ( DateField ) VALUES ( '09/05/2003' )" )

which works fine, so I assumed to insert a blank one would be:

SQLEXEC( lnHandle, "INSERT INTO MyTable ( DateField ) VALUES ( '' )" )

which doesn't work! I am getting the ODBC error 'Data type mismatch in criteria expression.'

Any ideas? I have also posted this in the VFP forum.

TIA
Neil

"I like work. It fascinates me. I can sit and look at it for hours..."

 

[BarkingFrog]

SQLEXEC( lnHandle, "INSERT INTO MyTable ( DateField ) VALUES ( NULL )" )

 

[Neil Toulouse]

Cheers dude!

Neil

"I like work. It fascinates me. I can sit and look at it for hours..."