Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force cursor field to accept NULL
Message
 
 
To
04/11/2005 11:19:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01065472
Message ID:
01065480
Views:
17
>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

Are you using VFP9? If so, you may try to use CAST function.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform