Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Or Just turn buffering on for table1 and do a tablerevert() within a begin/end transaction so that no changes get saved back to the table.
>
>Please show me how this is done. I've tried several different methods without success. What type of buffering on table1. Each time I've tried it the SELECT was ineffective. It selected all the records from table1, not just those that I had deleted in the DELETE FROM command. I would really appreciate a code snippet. Thanks in advance.
Dore,
Well after playing with it I have come to the same conclusion that you did. This will not work. I guess I just assumed that if you can see the buffered changes when you browse a table that you could do a select and get the buffered results. Looks like the select goes back to the table that is on the disk rather then the buffered changes or maybe
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