Help! Question about literal date strings and ADO

[B. Chernick]

I'm trying to write a web app in Dot Net 2.0 (VB) that accesses some old
FoxPro 6 tables, connecting through OleDb. By necessity I need to manually
write the Insert and update calls for the table adapters. One of the
requirements of the project is that certain date fields be automatically set
to a literal default value in the Insert function. The only way I've been
able to find so far is to include a Date(1899,1,1) call in the values string.
This works but the sql parser doesn't seem to like it much.

Does anyone know of an alternative? Every literal string format I've tried
so far has failed. (I have very little FoxPro experience.)

 

[Cor Ligthert[MVP]]

Hi,

I assume that you mean a New Date

However why not ask this in the relative active Microsoft Foxpro newsgroup
there they know for sure how to handle this with OleDB

Cor

 

[B. Chernick]

I'll give that a try. (Given the nature of the project, I wasn't sure
whether it was a Dot Net problem or a FoxPro problem, or both.)