Hi All

I have an appication that has a database of various People( Primary Key ID)
and Samplewords from speech (with the Transcript, Utterance_Number, and
UtteranceWord_Number as Primary Key).

There are 4 types of people (Parent, Client, Guardian, Professional, and a
general ALL category). When I try to insert a new entry to the People Table
using the GUI (having selected one of the People types using the
radiobuttons), I get the Key constraint INTEG_30. Sometimes the error does
not repeat itself and the 'Add new Person' form comes up showing the
selected option for Person type, however, other times the error comes up,
and no 'Person Type' is selected.

The INTEG_55 error occurs when I attempt to insert a second transcript into
the SampleWords table.

There is a trigger for the addition of a new Person to the People Table as
folows:

CREATE TRIGGER NEWPERSONTRIGGER FOR PEOPLE
ACTIVE AFTER INSERT POSITION 0
AS BEGIN
EXECUTE PROCEDURE NewPerson(NEW.ID);
END ^


I don't know what the errors are referring to exactly, but I guess the
software may not be selecting the correct radio button option for Person,
and so creating an error with an ambiguous type that does not fit the table
definition.

Thanks for your help,

Regards


Gaurav



--



Analyst
B. Engineering, B. IT
A.N.U (2004)

M: +61 401 409 620
H: +61 3 9376 8580


"In life, always do right. This will gratify some people and astonish the
rest."

� Mark Twain


[Non-text portions of this message have been removed]