I4GL Forms and SQL trigger
I run into a problem of using SQL trigger with UPDATE statement in
triggered action, because I4GL Forms generates m_record with all columns.
-- table definition
create table tab1 (
key_fld char(1),
fld2 char(2),
person char(8) )
--- trigger
create trigger upd_tab1 update on tab1referencing new as post
on each row( update tab1 set person=USER where key_fld=post.key_fld )
--- header.4gl
function llh_update()
...
update set key_fld=m_tab1.key_fld # the statement causes error -747
fld2=m_tab1.fld2, # see Error Message p.4 in "Using Triggers"
person=m_tab1.person # manual v.5.01 for explanation
where rowid=ring_rowid
...
end function
Is I4GL Forms impose other restriction on using SQL triggers?
Thanks in advance,
--
Vadim G. Park Tax Police Territorial Department, Krasnoyarsk, Russia
Fax: (391-2) 27-07-69, Voice: 27-02-83 E-mail: pivot@taxpol.krasnoyarsk.su