Hi Dejan

>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. ?

This is normal behavior for a Remote View. Since the PRimary Key is being created on the back end, VFP has no way of knowing what it is until you Re-Query the view.

All that a Remote View is doing for you is providing a wrapper around SQL Pass Through functions. There is no way that a change to a column made on the back end can be seen in VFP unless you do the requery.

>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.

I am not sure what you mean, you only need to re-query the view once, irrespective of how many updates you have made.