Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
>>I think what is happening is that after appending the blank record, my REPLACE commands are actually modifying another record, not the blank one. Then, subsequent APPENDs find the blank record, thus the duplicate index.
>>
>>It has been my assumption that after I issue the APPEND BLANK IN csrProjSessions, the record pointer in csrProjSessions will be pointing to the blank record I have just added. Is that a bad assumption?
>
>No, it's correct assumption unless some code moves record pointer between APPEND and REPLACE.
Hi Sergey,
Yes, that is what I thought. So, my APPEND BLANK command is followed immediately by a sequence of REPLACE commands to set values for each field of the new record.
I need to step through this more carefully to examine this hypothesis.
Jim
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