Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I'm trying to create a cursor of names,address,etc from the server (a local copy of the data) that can be used in a Grid. The users can then use the interactive grid search feature to locate the person to edit (data for that person will come from the server). I need multiple copies of this Grid working on multiple forms. When the user changes a record that information must be updated in the cursor and all of the Grids must be refreshed to show this updated data.
The table on the server has about 10 indexes, but the cursor I'm creating has an index on every field. This takes too long to download data from server and index every field. Each time the Grid is opened it currently creates the cursor and creates an index for each field. If there's a lot of names this takes time.
>>I'm trying to create a cursor with indexes that can be shared by multiple forms. I created a cursor and indexed in in Datasession 1. Then in a form with Private Data session tried to open it and got file in use. Is there any way to do this. I suppose could create a DBC and table and then use them.
>
>How do you create the cursor? SELECT INTO CURSOR
?
>
>If you put ?ISEXCLUSIVE( "MyCursor" )
after, you should see .T.
>
>FWIW, you're misusing private datasessions, IMO. If you want the form to use data that's been prepared by the calling code, then use default datasession. If you want it to prepare the data, have it call the code to prepare it.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement