This is most likely a multi user/concurrency control issue. The methods you
could use to lock tables will vary from DB to DB. If each user has a unique
userid, you could add 2 colunns to your table, userid and timestamp, assing
a var to the current time before you inser the row, insert the row w/ the
timestamp var and userid, and then select the rowid back out after you do
the insert for that user w/ the timestamp var.
Another way would be set up a control table, don't use autonumbering, and
manually select the control #, and incriment the control table, and use the
selected value.
Troy Sosamon
===== Original Message from [EMAIL PROTECTED] at 5/21/02 9:57 am
>OK I have fixed everything else data is where it needs to be and everyone
>was a big help.
>
>Here is my next issue.
>
>When I create a course with create_course.taf after the insert there is a
>DBMS that gets Max course_ID and set's it to a local variable.
>
>That is because I need to know what the course_ID that was assigned by SQL
>to the inserted course. I then use this to insert into the course_crosslink
>table the course_ID and some other values.
>
>It looks like sometimes it failed to set the correct course ID I guess there
>was some fast enough data entry going on from more than one person so the
>Max did not get the right number. At least it is the only thing I can think
>of that would cause the missing course_ID's in course_crosslink. Since the
>insert action comes right the DBMS I can see how it could fail without an
>error message to the user which I think I would have heard about.
>
>I know there is some way to lock the table or someway to make sure I
>retrieve the correct value but I don't know how to write it in WiTango or as
>a DBMS.
>
>
>
>--
>Dan Stein
>Digital Software Solutions
>799 Evergreen Circle
>Telford PA 18969
>215-799-0192
>610-256-2843
>Fax 413-410-9682
>FMP,Tango, EDI,SQL 7
>[EMAIL PROTECTED]
>www.dss-db.com
>
>
>________________________________________________________________________
>TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
