Hi Forum I am trying to use the IFM plug in, and it is unfortunately

lincolnf454 over 9 years ago

Hi Forum

I am trying to use the IFM plug in, and it is unfortunately not working for me

Please see the example below. I have a variable vTextOld in the destination process (this is the variable to be changed). This variable will be replaced by vTextNew in the process I am running with the IFM smart service.

="UPDATE 4623 SET PV vTextOld = [pv!vTextNew]"

Is my syntax incorrect here? I tried to make the input as simple as possible but I would also like to use a where clause, how would I add a where clause to an example like this?

I have also tried to use the query generator provided in the example application, also to no effect. If someone could give me an example of the parameters required for that expression rule, that would be of great help. Can that expression rule even be reused in my application?

Discussion posts and replies are publicly visible

Parents

0 lincolnf454 over 9 years ago

After some extensive testing, I have been able to use the IFM manager to update single cdt values successfully, like so

="UPDATE 4623 SET PV cdtTextOld.id = [" & pv!cdtTextNew.id & ""]"

Unfortunately I am still unable to update the entire CDT since I always receive the following error "Expression evaluation error : Cannot internalize type TEXTTYPE
" when using the externalize(internalize(cdt)) syntax.

Is this syntax provided in the documentation correct? Has anyone else had success when updating entire cdts through the IFM manager?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 lincolnf454 over 9 years ago

After some extensive testing, I have been able to use the IFM manager to update single cdt values successfully, like so

="UPDATE 4623 SET PV cdtTextOld.id = [" & pv!cdtTextNew.id & ""]"

Unfortunately I am still unable to update the entire CDT since I always receive the following error "Expression evaluation error : Cannot internalize type TEXTTYPE
" when using the externalize(internalize(cdt)) syntax.

Is this syntax provided in the documentation correct? Has anyone else had success when updating entire cdts through the IFM manager?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data