This content has been marked as final. Show 7 replies
You are correct
that the calculation in infomaker won't be saved to
the database. There may be a way to work around the
issue. I'd recommend contacting our Customer Support
group to see if there is a way to tackle this. You can
find information about contacting them here:<br
Thanks for the information James,
/>I received a recommendation of technical support
of Contract Manager that one road is usign API
application. We are going try for this road.<br
This really should be an enhancement request. This
feature has been needed for years.
(Primavera close your eyes)...
/>It is possible to write a custom trigger in the
database to perform this calculation whenever a change
is made to the value of either Custom Field A or B to
update the value in CF C.
in mind, this kind of thing is not supported and can
be risky especially when upgrading to a new version.
I have created custom sql schema that
does the calculation and I have scheduled using
Windows to run once a day. How to wirte a trigger?
please advise with a sample if prossible<br
What database are you running against? The syntax will
vary depending on the platform. Post your SQL you use
for the calculation. An alterntative to using a
trigger (and using a Windows scheduled task) would be
to schedule this within the database. I know that
Sybase has something called Events where you can have
this SQL run at specified intervals.
We use MS SQL 2005 (not express)