I'm doing something that feels terribly wrong, and I know there has to be a
"right" way to handle this...
I'm inserting a record, and then need to immediately access that records
indx (just a unique integer field); If I immediately use a select
statement
to return that record to get the indx value, the insert hasn't posted yet,
so
I do something like this:
insert blah blah
result=my select statement
do until not result.eof
result=my select statement
loop
eventually the insert posts and my result is populated. the problem
obviously is that if the insert fails for some reason I'm stuck in a loop.
I'd like to handle this like this, but I don't know how:
[some handle to the record] = my insert statement
So then I have some reference to the record in question as it posts. I'd
appreciate some insight however general it may be, I really don't know if
I'm
even thinking in the right direction.
Thanks for your time.
Sam Hall
sam@[EMAIL PROTECTED]
