Hi Brian,

As you had mentioned ISQL in your first thread, I assume you are using SQL Server. :)

The approach which I choose for this problem is by having a default value for each table's field on the server. There was no work-around when I looked for it so I guess this was the only way till SQL Server 6.5

>One problem I've had, is with Default values. None of the columns use NULL values, however when APPEND BLANK is issued each column defaults to NULL. This creates an error, obviously, unless each field is then initialized. IOW, both OLDVAL() and CURVAL() of each field is NULL. Yet, Defaults have been assigned in SQL Server but apparently these defaults don't carry over when Append-ing a Blank in VFP- ?? I'm not sure if this issue is connected to the slow Insert's but may be related.