Dear all,

I'm facing one strange problem as follow.
I'm using remote view to connect to SQL Database.

e.g; use rv_debtortran alias fdetail nodata share in 0 connstring sqlconnstr

After performed key-in transaction (Append into remote view), I use table update to send the data as follow.

Tableupdate(1,.f.,"fdetail")
SQLCOMMIT(sqlconnstr)

The problem goes here. I BROWSE the view before Tableupdate. The records are correct. But when I BROWSE the View after Tableupdate, The first line of the record was replaced by invalid data. It's only happened at the first row of the recordset. I still need to use that Remote View for posting to the other related tables. But the view is no more in valid state, that's why the other related procedures cannot be done. This thing's really driving me crazy. I really cannot find any error point which cause the problem. Is that be the Foxpro TableUpdate problem??? Or m I doing the correct way??? Hope to get some suggestions on this.

Thanks a lot in advance,
Mya.