unique file problem

[samsnead]

We have unique problem - we have two forms with private data sessions
- form A creates a unique file name using sys(3) and sys(2015) - this name is used for an index file.

uniquefilename = SUBSTR(SYS(3), 4, 4) + SUBSTR(SYS(2015), 7, 4)

form b has creates a cursor in the load event and also has a grid.

when both forms are open and we attempt to close form A, we get a file in use error when trying to delete the uniquefilename - all files have been closed using close data all

this only happens in combination with these forms - other forms can be open and closed no problem

any ideas?

 

[samsnead]

found the problem - form b was opening the file that form A was creating a tag for. form b was leaving file open so when form A tried to delete, could not. closed the file in form b and voila - works.

 

[lordhawkins]

Why don't you use a cursor in both of forms?
Create it using an SQL command with READWRITE parameter (VFP7 and up), then index the resulting cursor.
In the event of data change, use UPDATES.