General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problems returning dates to an Access .mdb backend
Using VFP 6.0 to create an updatable view to an Access .mdb backend. I need to return several fields for update. Everything gets updated except if there is a date field populated. I get a SQL Insert Into error for the date. Numerics and character fields have no problem. The table I'm updating is related to another in the Access container so I relate it in the view but don't use any of the fields in the related table. I think the view is set up appropriately. Need Help!
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only