I am attempting to re-set a variable using "Set Variable" and I am getting an error message "Variable "PersonMatch_MRN" could not be set (Script error: "Identifier is already in use." at script line 9)"

I tried to replicate this simply with create and set and set again and did not get this error. I have attached the code I was running in case it helps.  The only thing I can think of is the type nexted loops?

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMSQLOPENCONNECTION SESSION="AutoReg" CONNECTIONSTRING="AM19y9I4LjuL6U1z5kWV9qNz/ZnVd0xVs1aK/ATZJr6nvqzq0SUxGKseCmzf3sA0bAJFfwO7caO8VxQKlRZwBO0uo1kYgjLlz6n/poQgCblLO4gyfnpETTF3V1QPkWE2xQhX78qsDRztbYzVPNGteanvJxw2hbql0Ery84TnoAzrg4=aME" /> <AMSQLQUERY SESSION="AutoReg" RESULTDATASET="prereg">SELECT * FROM AutoReg_DATA</AMSQLQUERY> <AMVARIABLE NAME="CheckValue"></AMVARIABLE> <AMVARIABLE NAME="PersonMatch_MRN"></AMVARIABLE> <AMVARIABLE NAME="PersonMatch_LastName"></AMVARIABLE> <AMVARIABLE NAME="PersonMatch_FirstName"></AMVARIABLE> <AMLOOP TYPE="DATASET" DATASET="prereg"> <AMPRESS WINDOWTITLE="Person Search" OBJECTNAME="Reset" OBJECTCLASS="ThunderRT6CommandButton" OBJECTTYPE="PushButton" CHECKOBJECTNAME="YES" CHECKOBJECTCLASS="YES" CHECKOBJECTTYPE="YES" /> <AMIF EXPRESSION="%prereg.MedicalRecordNumber_Type = &quot;C&quot;%"> <AMSETTEXT WINDOWTITLE="Person Search" OBJECTCLASS="ThunderRT6TextBox" OBJECTTYPE="SelectableText" CHECKOBJECTCLASS="YES" CHECKOBJECTTYPE="YES" CHECKOBJECTPOSITION="YES" OBJECTXPOS="18" OBJECTYPOS="98">%prereg.MedicalRecordNumber%</AMSETTEXT> <AMELSE /> <AMSETTEXT WINDOWTITLE="Person Search" OBJECTCLASS="ThunderRT6TextBox" OBJECTTYPE="SelectableText" CHECKOBJECTCLASS="YES" CHECKOBJECTTYPE="YES" CHECKOBJECTPOSITION="YES" OBJECTXPOS="18" OBJECTYPOS="298">%prereg.MedicalRecordNumber%</AMSETTEXT> </AMIF> <AMPRESS WINDOWTITLE="Person Search" OBJECTNAME="Search" OBJECTCLASS="ThunderRT6CommandButton" OBJECTTYPE="PushButton" CHECKOBJECTNAME="YES" CHECKOBJECTCLASS="YES" CHECKOBJECTTYPE="YES" /> <AMSCRIPT>Function PrepMRNList(StrInput) StrInput = LCase(StrInput) StrInput = Replace(StrInput,&quot;(&quot;,&quot;&quot;,1,-1) StrInput = Replace(StrInput,&quot;)&quot;,&quot;&quot;,1,-1) StrInput = Replace(StrInput,&quot; &quot;,&quot;&quot;,1,-1) PrepMRNList = StrInput End Function </AMSCRIPT> <AMLOOP TYPE="LISTCONTROL" WINDOWTITLE="Person Search" OBJECTNAME="Scenarios" OBJECTCLASS="ListViewWndClass" OBJECTTYPE="List" CHECKOBJECTNAME="YES" CHECKOBJECTCLASS="YES" CHECKOBJECTTYPE="YES" CHECKOBJECTPOSITION="YES" OBJECTXPOS="163" OBJECTYPOS="37" RESULTDATASET="p"> <AMSET VARIABLENAME="PersonMatch_MRN">0</AMSET> <AMSET VARIABLENAME="PersonMatch_LastName">0</AMSET> <AMSET VARIABLENAME="PersonMatch_FirstName">0</AMSET> <AMIF EXPRESSION="%prereg.MedicalRecordNumber_Type = &quot;C&quot;%"> <AMLOOP TYPE="LIST" LIST="%PrepMRNList(p.MRN)%" RESULTVARIABLE="CheckValue" DELIMITER="semi_colon"> <AMIF EXPRESSION="%CheckValue = prereg.MedicalRecordNumber%"> <AMSET VARIABLENAME="PersonMatch_MRN">1</AMSET> <AMBREAK /> </AMIF> </AMLOOP> <AMELSE /> <AMLOOP TYPE="LIST" LIST="%PrepMRNList(p.[Referring MRN])%" RESULTVARIABLE="CheckValue" DELIMITER="semi_colon"> <AMIF EXPRESSION="%CheckValue = Trim(prereg.MedicalRecordNumber_Type) + &quot;-&quot; + Right(&quot;000000000000&quot; + Trim(prereg.MedicalRecordNumber),12)%"> <AMSET VARIABLENAME="PersonMatch_MRN">1</AMSET> <AMBREAK /> </AMIF> </AMLOOP> </AMIF> <AMIF EXPRESSION="%UCase(Trim(Split(p.Name,&quot;,&quot;)(0))) &lt;&gt; UCase(prereg.PT_LastName)%"> <AMSET VARIABLENAME="PersonMatch_LastName">0</AMSET> <AMIF EXPRESSION="%UCase(Trim(Split(Trim(Split(p.Name,&quot;,&quot;)(1)),&quot; &quot;)(0))) &lt;&gt; UCase(prereg.PT_FirstName)%"> <AMSET VARIABLENAME="PersonMatch_FirstName">0</AMSET> <AMELSE /> <AMSET VARIABLENAME="PersonMatch_FirstName">1</AMSET> </AMIF> <AMELSE /> <AMSET VARIABLENAME="PersonMatch_LastName">1</AMSET> </AMIF> <AMIF EXPRESSION="%Format(prereg.PT_BirthDate_D,&quot;MM/DD/YY&quot;) &lt;&gt; Format(p.[Birth Date],&quot;MM/DD/YY&quot;)%"> </AMIF> </AMLOOP> <AMIF EXPRESSION="%PersonMatch_MRN = 0%"> <AMMESSAGEBOX>Match FAILED</AMMESSAGEBOX> <AMELSE /> <AMIF EXPRESSION="%PersonMatch_LastName = 0%"> <AMIF EXPRESSION="%PersonMatch_FirstName = 0%"> <AMMESSAGEBOX>Match FAILED</AMMESSAGEBOX> </AMIF> <AMELSE /> </AMIF> </AMIF> </AMLOOP>

Quite a few tasks steps there so I can't exactly replicate - however, I noticed you were trying to loop through the result of a custom BASIC function. Are you sure that is what you are intending to do? I am not sure it makes sense because it would change every iteration right?

Did you ever have this task working in a previous version of AutoMate this way?

Category Survey

-------------------------
Dustin Snell

Everytime I post it is something simple like that.

That was the problem that VB code was supposed to be at the top outside all loops.  Thanks for the help.

Category Survey

Great I am glad you have it solved!

Category Survey

-------------------------
Dustin Snell


Edited: 02/16/2009 at 09:58 PM by Dustin Snell

I'm getting that error too, in a script that runs fine when it is the first time a step of a task runs it. When it runs the second time, I get this error. I was able to eliminate the error by undoing a (very) recent change.

I had a loop that built a large list, and then a query that used that list. The size of the list was making the query time out, so I broke it up. instead of this:

do while ...
make list bigger
loop
Use list in query

I did this:

Sub useList( list, connection1, connection2 )
Use list in query
End Sub

do while ...
make list bigger
if Len(list) > 5000 Then
useList( list, connection1, connection2 )
list = ""
End if
Loop
useList( list, connection1, connection2 )

When I removed the new Sub and pasted the code into both places that I had "useList", the error went away. I am mystified.

Category Survey

Dave,
I suppose the whole script resides inside an Automate loop.
A sub (useList) can only be defined once
The
Sub uselist(....)
End Sub
must be placed first, outside of any loop.
I guess on the second run your script was trying to define again uselist, so that it failed.

Category Survey AutoMate 7 version: Windows version:

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4