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