>>>Hi,
>>>
>>>Say I have a form with textboxes bound to a cursor (retrieved from a SQL Server via SPT) and some values in the cursor are NULL. I prefer that the customer does not see the NULL but instead an empty textbox. How do you hide the NULL from these textboxes?
>>>
>>>Also, I prefer not to change the value in the cursor from the NULL to empty string for 2 reasons: 1 time that this procedure will take 2 - on Save I would have to convert the value back to NULL.
>>>
>>>TIA.
>>
>>Check:
>>SET NULLDISPLAY TO command
>>and
>>Object.NullDisplay property in HELP.
>>
>>BTW If the NULL values are NOT needed at all I prefer to set default value to empty field (depends of its type). Only type that allow NULLs is datetime :-)
>>Of course this is dependong the application, sometimes NULLs are mandatory.
>
>Thank you for the NULLdisplay suggestion.
>
>As far as setting default to empty value, I thought about it. The only issue is then if the column/field is a foreign key the primary key (to which RI constraint is set) has to have a row with an empty value. And this would be (IMHO) some maintenance headache.


IMHO the headache will be to manage a parent - child tables where in child table you have records which are not presented in parent one, but again - that depends of the application.