>something like: ..(515)MS ODBC ... Cannot insert the value Null into
>column ... INSERT fails .
Do you know which column the error refers to? If it is the PK column in the table and you are using remote views (or a remote view definition for an updateable SQL PassThru cursor) make sure that the column (in the RV definition) is marked as updateable. If it is not, then you PK value will be set in the Fox client-side cursor but will not get sent to the back-end table. In this case, a NULL value might be trying to be written to a non-nullable PK column.
>What I really need to know is WHERE and how is triggered stored procedure
>for incrementing Primary Key counters ? Where should I look for and follow
>the execution after I append new record ?
If the PK in the SQL table is not an identity column, then if you use Codemines lAutoAssignPrimaryKey mechanism or just simply call the PrimaryKey() function in AfterNew(), then if you are using a SQL back-end, the function automatically calls sp_cm_IncrementCounter.
-=Gary