Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force cursor field to accept NULL
Message
From
04/11/2005 11:19:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Force cursor field to accept NULL
Miscellaneous
Thread ID:
01065472
Message ID:
01065472
Views:
60
I create RW cursor by selecting constant expression
I want to store NULL to the created field later
How to force cursor field to accept null values ?
ALTER TABLE c2 NULL cannot be used since real cursor contains some hundreds of columns need to allowed nul values and lot of rows.

Code to reproduce:
CREATE CURSOR test ( c1 char NULL )
APPEND BLANK

APPEND BLANK
SELECT  '' as c2 FROM test INTO CURSOR test1 readwrite
REPLACE c2 WITH null
Observed: program error
Field C2 does not accept null values.

Expected: no error
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform