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
