Hi All,

I would like to insert all the values at the time of saving in remote view but oracle or Foxpro doesn't save the value for primary key. Once i am on the record ( remote view ) which i am updating or adding only after REQUERY(), value in my primary Key field appears.
Expl.
TEST with 2 fields NAME C(20) and PK NUM (10)
PK field is set to be Primary key, not allowed NULL and value has to be unique.
There is trigger TEST_NUMBERING which inserts the value in PK field before insert.
..and SEQUENCE TEST_NUMBERING_SEQ for taking the next value from the row.

I have record buffering enabled and after inserting the values in the name i issue TABLEUPDATE(.t.,.t.,'test')
I name my remote view TEST but value in PK field doesn't appear until i REQUERY() the view.

Is this normal behaviour of ORACLE8i and can i change it to be like in SQL Server for expl. ?

If i have a big table with hundreds of rows it will reflect on the performance i.e. as tables are getting bigger and bigger time for just inserting the record will be longer and longer.

Thanks for any insights.

Dejan