>Upon append, the record shows in the browse.
>After END TRANS, I do a browse and nothing shows. I escape and browse again and then the record is gone.
>
>I do not do tableupdate, because I am not currently using buffering while testing this.
>
>>Try the following code so you can detect where is it that you are loosing your records.
>>
>>USE tablename
>>
>>BEGIN TRANSACTION
>>APPEND FROM temptable
>>browse && do you see your new records?
>>END TRANSACTION
>>browse && do you still see your new records?
>>
>>? tableupdate( 2, .T. )
>>USE
>>
>>USE tablename
>>browse && do you still see your new records?
Larry, try the following:
USE table
MODI STRU, add a field, hit ok
MODI STRU, delete the field, hit ok
Try the append again.