I can't think of anything. We do that sort of thing a lot and it can work, although I'm trying to use more SQL syntax.
INSERT INTO (ca.Alias) Field1, Field2 SELECT Field1, Field2 FROM Table.DBF
UPDATE (ca.Alias) SET Field1 = otherCursor.Fieldx FROM (ca.Alias) JOIN (othercursor2) ON ...
Obviously, you can probably avoid the update/replace entirely by INSERTing from a good SELECT statement. You are using VFP 9 and it really has good SQL abilities.
Otherwise, just check the normal stuff. TableUpdate for all rows? What's the GETFLDSTATE() after the insert?
>I am having a wierd issue with a Cursor Adapter
>
>If i insert one record with an append blank and then replace the values with REPLACE, works well, however in some particular part of the code i perform a APPEND FROM TABLE.DBF
>
>then, i need to bring a value from another table and update one particular field so I perform a Scan EndScan
>
>when the cycle is over, I browse the CA an the value is there, but when i see the sql table, ain't it.
>
>i even run atableupdate and nothing
>
>any ideas??
Charlie