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:
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
