Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view, NULL and Fox 2.x tables
Message
 
To
12/12/2000 07:53:29
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00452125
Message ID:
00452152
Views:
19
Thanks, Cetin. This seems to have cleared up the problem for all field types except date fields. Any ideas on how to force date fields to blank, not NULL?

Again, thanks for your help.

Nancy

>>Hello,
>>
>>I'm working on a VFP 6 application that must reference .dbf files which are still used by a Fox 2.6 application. The VFP application must also be used across a T1 so I am using remote views to keep performance at an acceptable level.
>>
>>My problem is that VFP returns a "NULL not allowed" error on Tableupdate(). Should I be initializing every field to blank when I append a record (or check each field for NULL if editing) before issuing Tableupdate()?
>>
>>Any help or comments will be appreciated!
>>
>>Nancy Price
>
>Nancy,
>You could initialize all blank :
>select myView
>scatter memvar memo blank
>insert into myView from memvar
>Cetin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform