Hi Mark,

My SET NULL is OFF. SET NULL is only useful if I want all fields to allow NULL or not allow NULL. I only want to set the default value to NULL for those remote fields which allow NULLs. Not all of them do, primary keys for example. I want to create the table and loop through each field and set it's default value to NULL if the remote field allows NULL. This way I will be getting exactly the same results as though I were inserting records directly into the remote table.


>Do you have SET NULL ON???
>
>Mark
>
>>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