Hi,
Just doing some testing at the moment and trying to make a trigger that consists of a insert statement which as a result of an sql querty!
Is this possible? if so could someone give me some pointers as i am having no luck trying to get this to work, have even tried this but still doesnt work.
begin
begin
INSERT INTO wip.resourceplan
(
"name",
"notes",
"hrs",
"glcode1",
"glcode2",
"chargeratename",
"chargeratevalue",
"servicefeename",
"servicefeevalue")('1','2','3','4','5','6','7','8','9')
return null;
end;---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
