Hi!

Glad you figured out something.
You can expect the matching keys in the table and view. However, record in the table do not appear until you update the view. Beware about automatic view updating as soon as record pointer moved. This happens also if you browse the view. So probably you have been cnfused by automatic update. Try following:

Open the view
CursorSetProp('Buffering',5)
INSERT INTO MyView ...

Than browse. You will see record in view, and no record in the table. With 5-th buffering only Tableupdate() will update data in table. Try that and see if key in the table match to the key in the view. If the key field of view is not updatable, you will get no match, thus incorrect functionality of view. If it is updatable, table will contain the value from view.

Than add next record and see if there is a gap in the value.

Do the same with Append Blank.

Note that table should not be buffered in such case. Otherwise there might be gaps in the key values too.

HTH.


>Vlad - thanks again for your help...
>
>I am getting the gaps as you say!!! In fact that was the reason I first posted about this because I thought "This just can't be right!!!"
>
>Also I have noticed that even thought the PK in the view is updateable the GetNextID function is not being called from the base table - there are no entries in my Counter table??!!
>
>Would you expect always to see in the Counter table...
>
>TABLE NEXTID
>CUSTOMERS 12
>V_CUSTOMERS 12
>
>I.e. the table and the view in unison?