Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Include NULL in the result
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01036945
Message ID:
01036967
Views:
16
>>Me too
>
>There is minor problem with this solution. It says the field doesn't accept nulls. I'm afraid I would not be able to alter cursor unless I change the structure and made first field shorter...

Then instead of APPEND BLANK use :
INSERT INTO .... VALUES (" ", " "," ") 
Just add empty values depending of the type of columns.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform