2 Replies Latest reply on Apr 26, 2013 8:51 AM by schamblee

    Go to record issue?????

    leonaisse

      Title

      Go to record issue?????

      Post

           Hi

           I have a simple GO To record issue? I am inserting a record, i set the variable $POID to the value of the inserted recordID switch layout and then try to go to record by calculation using the variable $POID. But i get a 101 error? Attached is my script, can anyone tell me why my GTR returns 101. Using the data viewer suggests that my values are correct?

            

           Thanks in advance

            

           Leonaisse

      Capture.JPG

        • 1. Re: Go to record issue?????
          philmodjunk

               Go to Record/request/page does not go to a records with a specific value in a field. It puts the focus on a specific record by its specified position in the current found set.

               If you use:

               Go to record/request/page [ 5 ]

               you make the 5th record in the current found set the current record.

               To further confuser your results you are using a boolean expression in this step: dbo.accounts::ID = $POID. That expression will either return a 1 ( the values are equal) or a 0 (The values are not equal). Thus, if the result is False (o), you get the error code you have reported.

               Instead of new window, you might try using Go To Related Record with the new window option. This will require a relationship (probably a self join) such that you can use set field to put the POID value in a match field and then GTRR can pop open the new window and make the specified record the current record.

          • 2. Re: Go to record issue?????
            schamblee

                 It looks like you are trying to set the value of the variable in your go to record statement.   Your go to record statement needs the record number you want to go to.   You have already set the value at the top of your script.    Try Go to Record[No dialog;$POID]