Steve,
Thank you for taking the time to read my posting and offer the article for reading.
To answer your question, all tables are in the same DBC.
>Joe,
>
>Just glancing at the code, I see one potential problem--especially in a high traffic environment. You have no guarantee that your nextId's are unique using this method...you attempt to check if the ID already exists, but there still is a delay before you insert the new value. I kept the code in question below.
>
>VFP8 has autoInc ID's built in...
>
>But, in the meantime, check out the article on primary keys at
www.craigberntson.com. You basically use the default value of the field to fetch the next ID.
>
>BTW, are these free tables, or part of a DBC?
>
>>
>>This post is long, so please bear with me....I have a rather frustrating hard-to-pinpoint problem happening with my application.
>>
>>ANY help/suggestions are MORE than welcome!!
>>
>>
>>
>
>> *** Now get the next instance sequence
>> cInst_id = NextId('INST_ID')
>>
>> SELECT INSTANCE
>> SEEK CINST_ID
>> IF FOUND()
>> DO WHILE FOUND()
>> cInst_id = NextId('INST_ID')
>> SEEK CINST_ID
>> ENDDO
>> ENDIF
>>
>> *** Update the instance and results tables
>>
>> select instance
>> =cursorsetprop('buffering',5)
>> select results
>> =cursorsetprop('buffering',5)
>>
>> SELECT INSTANCE
>>
>> *** Update the instance table
>> INSERT INTO instance (inst_id, dc_grp, .... < snip >
>> VALUES (cInst_id, M.dc_grp, lDeviant, < snip >
>