>I have a system which uses a database on the network and another local database. I set the 'default' to the local directory and the 'path' to the network. Everything is fine with this setup. I have a form which creates a cursor in the load and closes it in unload. If this form is opened by more than one user do they end up using the same cursor? I believed that a cursor by definition would be local but am having doubts as some calculations based on the cursor fields are randomly incorrect. So where is the cursor created?
>Using a random name for the cursor would resolve the conflict but I would like to know what foxpro does as I use a lot of cursors...
You have another problem, because the cursor is ALWAYS created locally. Create a cursor, and you can find its name and location by ?dbf('yourcursor').