Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC Default date value problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00155383
Message ID:
00155759
Views:
17
>>Enter your dat constant as a strictdate format, that is {^YYYY/MM/DD}
>
>Hi Jim,
>
>That is how I have been entering my dates since DevCon. It seemed like a good habit to get into. But, this is the first time I had set strictdate to 1 in VFP6. Once that was set, I started getting errors from the DBC for my default values on date fields. Upon further examination, the DBC appears to store the date constant in the old format {MM/DD/CCYY}. Unless I set strictdate to 0, I get errors.
>
>Does that contradict your observations?
>
>TIA,
William,

Here's what I just did.

Set Strictdate to 1

Created a database
Created a table with one date field and set the default for that field to
{^1998/01/01}

Browsed the table and used Table-Append New Record 10 times to put records in the table.

I got no errors at all from VFP6.

Are you doing something different?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform