Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem using DefaultValue, view and SQL INSERT in VFP6???
Message
From
21/09/1999 11:16:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem using DefaultValue, view and SQL INSERT in VFP6???
Miscellaneous
Thread ID:
00267129
Message ID:
00267129
Views:
55
I am seeing a problem in VFP6 when I have a local view with a DefaultValue. If I APPEND BLANK, the DefaultValue is loaded and ultimately written to the table. However, if I use INSERT, the DefaultValue is loaded but not written to the table. If I use GETFLDSTATE(), the field in question will have a 3.

Running the same test in VFP5, the field will have a 4 as expected get written to the table using APPEND BLANK or INSERT.

Is this widespread? I checked MS Knowedgebase with no luck.

-Doug-
Reply
Map
View

Click here to load this message in the networking platform