Tadeu, I can explain it, but the solution is not so easy.
The field 'Group' (on "MY_FORM") is a character field. However the 'Group ID' field on "Group" is an integer field. Your database is complaining because your comparing an Char with an Int. I would suggest that you create your own "MyGroup" form and populate it with data from the AR System "Group" form. That way you can have an Integer 'Group ID' field and a 'Group ID As String' field too. ( Without risking changes to the AR System "Group" form.) Then you can do your test against the "MyGroup" form and the 'Group ID As String' field. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Wed, Feb 20, 2008 at 4:42 PM, Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> wrote: > ** > > > > Good Evening for all... > > I'd like to know if there is a possibility that I use a 'Set Field' or 'Push > Field' action on this case: > > First, let's consider that I work with "only one" value on 'Group List' > field (Form User).. > > I've created a Filter that work like this: > Form Name: User > Run If: 'Group List' != $NULL$ > If Action: Push Field > - Server Name: Current Server > - Push Value To: "MY_FORM" > -- Push Field If: ( $Request ID$ != 'Entry-Id') AND ( 'Entry-Id' = > $NULL$ ) > -- Fields: 'GROUP' = $Group List$ > > P.S. > // "Entry-Id" and "GROUP" are from MY_FORM form. > > > > Well, what's happenin' ??? > > My field 'GROUP' (on MY_FORM form) is receiving the ID from the Group that > was in $Group List$ field from Form User... > > I'd like to know if there is a choice that I put the Group Name of these ID > in my field 'GROUP' (on MY_FORM form)? > > What have I done?? > > I have done an Active Link that makes a 'Set Field' action like this: > Form Name: MY_FORM > > Run If: 'GROUP' != $NULL$ > If Action: Set Fields > - Server Name: Current Server > - Read Value for Field From: Group > -- Set Field If: 'Group ID' = $GROUP$ > -- Fields: GROUP = $Group Name$ > > > P.S. > // Where: > // - GROUP is from MY_FORM form; > // - 'Group ID' and $Group Name$ are from Group form (Form of AR System) > > > But this isn't running... > I received the following message: > > "ARERR [313] Data types are not appropriate for relational operation > The preceding message occurred during the execution of active link MY_FORM > -- action 1. (ARNOTE 1101)" > > > Can anybody help me??? > I'm avaiable for question and answers... > > Thankx a lot in advance... > > Tadeu Augusto Dutra Pinto > -----------------------------------------------------------------IT Web > Services ATM > Cinq Technologies > http://www.cinq.com.br > [EMAIL PROTECTED] > > Fone: 41 3018-2833 - Cinq > Fone: 41 2107-5736 - HSBC Outsourcing > ----------------------------------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
