Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Selecting from an open table
I have a cursor open with table buffering to which records get appended. At one point in my form I would like to "resort" all the records in order to perform some checks before the records get saved. So, what I would like to do is a SELECT * FROM ALIAS() ORDER BY fields
Therefore re-sorting all the records that are in the uncommited table in memory. However, this SELECT statement gets the fields from the commited records in the table, not the current uncommited table in memory. What can I do?
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