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 >
>