General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only