Printable View
i am developing a hostel management software using java as a frontend and a derby database as a back endn in my software i can create multiple hostel tables and the user can enter records in these tables... however i need to create a jdbc trigger in each table before insert that checks if the record being entered on a current table exists on another table, can anybody help me do this please, its urgent
It's all in the JavaDB Reference Documentation.
kind regards,
Jos
thanks so much for your prompt reply, however i seem to be tottaly stuck when it comes to creating the sql statement in the trigger body i have been skimming through the guide practically the whole night and derby doesnt seem to support "if exists". could u pliz point me in the right direction when it comes to creating the sql statement to perform the referential check?
i have also been trying to create the trigger i keep encountering sql exceptions when trying to use if and where clauses
(LOL!!! NICE JOKE)