Hi All,

My situation
------------
I have a table MYTABLE.DBF whose PK is field1 and the default value as "NewMyTableID()". This "NewMyTableID" is defined in Stored procedure to automatically get the maximum number in field1. I have created a remote view (named CURSOR_MYTABLE) and choosen Key as "field1", all other fields as updateable, Send Updates to TRUE.

My problem
----------
When I append a record in CURSOR_MYTABLE without assigning any value to field1 and use TABLEUPDATE(), the system says "Index does not accept null values". Why is it the case, when I have given the default value to be assigned by executing the stored procedure?

The table is properly updated if I make the key field also as updateable and send a non-unique value from program. I do not want it this way - assigning thru program. I want to assign by the system automatically thru stored procedures. Any help would be appreciated.

Thanks in advance.