You'll get the same problem if you're using a view, in which you've modified data and you try to requery(). You need to either Tableupdate or Tablerevert before you re-rerun the SPT.
>Hi All
>
>I ran into a new one to me. I am going against a Sybase database on this project and my framework is using only SQL passthrough. I set cursor buffering to 5 so I can find any changed columns using getnextmodified() and getfldstate(). What I have just found is if I have inserted data into a cursor (recno < 0) that vfps select statement can't retrieve the data. Is there a way around this?
>
>Thannks for your help.