Hi Don,
1) Are you working on a Network? If so is there a Write Cache which may be delaying getting data back to the server's hard disk? If so, this has to be corrected by the SysAdmin, not through VFP.
Also, do you have tables opened in the Default Datasession and then reopened by the form in its Private Datasession? This is the default method in Visual MaxFrame (and possibly other frameworks) because of speed, however tables in the Private Datasession use a "USE AGAIN" command and copy data from the tables opened in the Default Datasession.
2) It sounds like your cursor is really a filtered record set. This happens when you select records from a single table and have no calculated fields. To prevent this simply use the "NOFILTER" clause in your SQL statement. If you're using VFP3, you'll need to add a calculated field such as
Select Myfield1, Myfield2, .f. as MyNewField from Mytable into cursor curTemp
This will give you a true cursor, separate from the table.
HTH
Barbara
>Hi All,
>
>Noticed a couple of weird things the other day. My application uses a Database Container and the my main form
>has all of it's files (from the container) opened in it's Data Environment. I've been told that using a container and
>the Data Environment might lead to some problems but todate it's been pretty stable. What I've noticed is when an index
>file has become corrupted some Data hasn't been written to various files.... kind of like the files has been cashed
>somewhere and if the machine locks up it's a if an the update never happened. Do I need to always use the flush
>command to force updates to files quicker ?
>
>The other situation is when I use a cursor on a perticular table and attempt to position on specific record number in
>the cursored table the record number returned to me is the number from the original table not the cursor.
>
>
>thanks in advance,
>
>Don