Upcoming release will fix some problems with triggers. Perhaps yours falls
under fix.BEFORE INSERT/BEFORE UPDATE TRIGGERS SYS_NEW Virtual row become
update-able. All other times SYS_NEW and SYS_OLD virtual rows are read only Jim
Bentley,
American Celiac Society
1-504-737-3293
From: Albert Berry <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Friday, November 21, 2014 6:44 PM
Subject: [RBASE-L] - Re: Using Triggers
Tony, the column is only computed once the row is saved, and then the form
needs to refresh. You need to add these lines to either the eep calling the
stored procedure, or if the procedure is only used in the form, in the
procedure itself.
PROPERTY TABLE <FORMTABLENAME> 'POST'
PROPERTY TABLE <FORMTABLENAME> 'REFRESH'
That will show you the result on the form
Albert
On 11/21/2014 1:27 PM, Tony IJntema wrote:
<!--#yiv0308998675 _filtered #yiv0308998675 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv0308998675
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv0308998675
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv0308998675
{font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv0308998675
#yiv0308998675 p.yiv0308998675MsoNormal, #yiv0308998675
li.yiv0308998675MsoNormal, #yiv0308998675 div.yiv0308998675MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv0308998675 a:link, #yiv0308998675
span.yiv0308998675MsoHyperlink
{color:blue;text-decoration:underline;}#yiv0308998675 a:visited, #yiv0308998675
span.yiv0308998675MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv0308998675
p.yiv0308998675MsoAcetate, #yiv0308998675 li.yiv0308998675MsoAcetate,
#yiv0308998675 div.yiv0308998675MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
"sans-serif";}#yiv0308998675 span.yiv0308998675BalloonTextChar
{font-family:"Tahoma", "sans-serif";}#yiv0308998675
span.yiv0308998675EmailStyle19 {font-family:"Calibri",
"sans-serif";color:#1F497D;}#yiv0308998675 span.yiv0308998675EmailStyle20
{font-family:"Verdana",
"sans-serif";color:#1F497D;font-weight:normal;font-style:normal;}#yiv0308998675
span.yiv0308998675EmailStyle21 {font-family:"Verdana",
"sans-serif";color:#1F497D;font-weight:normal;font-style:normal;}#yiv0308998675
.yiv0308998675MsoChpDefault {font-size:10.0pt;} _filtered #yiv0308998675
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv0308998675
div.yiv0308998675WordSection1 {}--> Using a trigger I encounter a problem
which I don’t understand. I have to fill a text column which has to be
computed as follows: Year as text + Daynumber as text + Primary Key as text
I have written a stored procedure which needs to be executed after the insert.
I am catching the last used PK using the where clause as count=insert It
works almost ok, but if I insert a new row the column is still empty and if I
insert another row the concerned column of the new rows is empty, but then the
column is filled in row which I have created before the last one. Why does
it works this way and what do I have to do to have the column filled when the
particular row is created and not one row later? Tony
