Ricardo,
The negative record #s can cause problems. Also, if you're using a SELECT statement to copy the data it won't work because it won't see the buffered data (that's a feature, not a bug :-) .
What command are you using? Copy? Select?
Barbara
>Hi all,
>
>I have a remote view (to SQL Server) with two records (i'm using Buffering = 5). Right after inserting these 2 records, i click on a button that should copy those 2 lines, change one field, and insert them into the same remote view.
>The problem is: i try to copy those values to an array, but they are reaching empty. Does it have anything to do with being Buffered? I've noticed the RECNO() is negative (we know that with buffering happens this until we do a TABLEUPDATE).
>Any idea? I'm stuck in this.
>
>Thanks,
>
>Ricardo