>Hello
>I put the ISNULL() function on the T-SQL code because the error in FOX 'Field XXXXXX does not accept null values.'
>Do you know any way of getting blank or default values in this cases automaticaly?!
>
>THANKS ALREADY!
Blank and NULL values are separate animals. Default values are only used when initially inserting (or appending) a record and the value wasn't explicitly specfied.
So no, I don't know of another way to do this on the T-SQL side. You could change your FoxPro stuff to allow NULLs and then process those out in VFP using the NVL() function (as Bill kinda suggested) and an Update/replace statement.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao