Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Abnormal behaviour of INSERT command
Hello all,
I am experience an Abnormal behaviour with the INSERT command
1. I INSERT into a table say 'tableA' that is not curretly selected
2. I update the grid which is based on a cursor say 'cursorA' which in turn derives it records from tableA using a SELECT statement
3. All goes well i see the newly added record in the grid.
4. If the machine goes off e.g power failure then upon restarting the application the grid displays without the newly addded record.
5. I presume it's damaged or so so i attempt to recreate it as in step 1 & 2
6. Then the old one (presumed damaged and the recreated on both appear giving a duplicate.
A browse of the table after restarting windows shows the record with some values changing haphazardly.amazing!
I am NOT using buffering (row or table). Table has no index. I realise this does not happen with APPEND & REPLACE.
Is this by design? Any way out?
Any help or advice will be appreciated.
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