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