Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Sergey,
In my application the users query a table. The matching records from the table queried and other tables that are linked to this table are displayed to the user.
The other tables are connected to the table queried using Set Relation command.
I was also using 'Set Filter' commands to filter certain records.
But it was notices that using 'Set Filter' made the searches very slow. So now I am recoding so that I use Select SQL statements to extract data to variuos cursors, and the data is displayed to the users off of these cursors. It has made the searches quicker.
But now my problem is that since the cursors are not related, when I move to another record in the 'queried table' the pointers in the other tables do not move as well. I was wondering whether, I could accomplish this with the Select SQl.
Ria.
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