Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to determine if field in SQL Server table support NULL
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
How to determine if field in SQL Server table support NULL
Miscellaneous
Thread ID:
00173848
Message ID:
00173848
Views:
68
I am creating Fox tables on the fly which are identical to their SQL Server counterpart. The only thing that doesn't work well is the fields in the Fox table, while they will allow NULLs if the remote field does, they do not default to NULL. This means when you do an APPEND BLANK or INSERT - SQL into the Fox table the numeric fields default to zero instead of NULL. I want to set the default for the field to be NULL if the remote field allows NULLs. I can do this with DBSETPROP, but I need a way of determining if the remote field supports NULLs

Is calling SQLCOLUMNS with the NATIVE clause the only way to determine if a remote field supports NULL values?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform