PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/18/2013 7:22 AM by  wilcoxmad
Call to form in DS gives me a data window?
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
wilcoxmad
Private
Private
Veteran Member
(231 points)
Veteran Member
Posts:87


Send Message:

--
09/17/2013 12:02 PM

    I build a string to do a form call to custom form CC42. This is my URL:

    https://zzz211.myserv.com/servlet/Router/Transaction/Erp?_PDL=DEV&_TKN=CC42.1&FC=I&_ID=CC42.1_CUSTOM&QIC-COMPANY=1&SUPER-EMP=37115&QIC-YEAR=2013&QIC-QUARTER=2&_OUT=XML&_EOT=TRUE

    This pops up in a new window but it has the following text instead of the form???
     Any ideas?

    xml version="1.0" encoding="ISO-8859-1" ?>

    - <XCC42.1>

    - <CC42.1>

      <_PDL>DEV_PDL>

      <_TKN>CC42.1_TKN>

      <_f0>CC42.1_f0>

      <_f1>I_f1>

      <_f2>0_f2>

      <_f3 />

      <_f4 />

      <_f5>12_f5>

      <_f6 />

      <_f7>1_f7>

      <_f8 />

      <_f9>37115_f9>

      <_f10 />

      <_f11>2013_f11>

      <_f12>2_f12>

      <_f13 />

    ……

     

      <_f109r11 />

      <_f110r11 />

      <_f111r11 />

      <_f189>0001000037115_f189>

      <Message>No Quartlery Data FoundMessage>

      <MsgNbr>105MsgNbr>

      <StatusNbr>001StatusNbr>

      <FldNbr>_f9FldNbr>

      CC42.1>

      XCC42.1>

    David Williams
    Private
    Private
    Veteran Member
    (3076 points)
    Veteran Member
    Posts:1036


    Send Message:

    --
    09/17/2013 12:30 PM
    What are you actually trying to do? The Out=XML reference asks you to return the call in XML format.
    David Williams
    David Williams
    Private
    Private
    Veteran Member
    (3076 points)
    Veteran Member
    Posts:1036


    Send Message:

    --
    09/17/2013 12:31 PM
    You aren't sending a call to open a form, but to do an Inquire call on a form.
    David Williams
    wilcoxmad
    Private
    Private
    Veteran Member
    (231 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    09/17/2013 1:31 PM
    So can you tell me what I am doing wrong? And maybe how to fix it!
    David Williams
    Private
    Private
    Veteran Member
    (3076 points)
    Veteran Member
    Posts:1036


    Send Message:

    --
    09/17/2013 1:47 PM
    Well, I didn't want to assume I knew what you were doing but if you're trying to open a form from another form modified with Design Studio, you have a couple of options. You can add a button and use the Form Open or Form Transfer action - this should work if your key fields are the same (they should carry over to the opened form).

    Will that work or do you need to use a Script?
    David Williams
    wilcoxmad
    Private
    Private
    Veteran Member
    (231 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    09/17/2013 2:09 PM
    David,
    This: I am trying to open a form from another form modified with Design Studio, you have a couple of options. You can add a button and use the Form Open or Form Transfer action - this should work if your key fields are the same (they should carry over to the opened form).
    The key fields do NOT carry over. Only the company and employee carry over. The year and quarter do not.
    Since that was not working I was trying to script it and make that work. That is where I am running into the problem described above.
    Thanks.
    wilcoxmad
    Private
    Private
    Veteran Member
    (231 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    09/17/2013 2:13 PM
    Here is what how I was tryig to pass the keys, which is what I would really like to get working:
    if (id == "push3")
    {
    var vEmpA = lawForm.getDataValue("MANAGER",2);
    //pad the employee # with leading zeroes
    var vEmp = "000000000".substr(0,9-vEmpA.length).concat(vEmpA);
    var vHK="000"+vCompany+vEmp+vYear+vQtr;
    //alert(vHK)
    lawForm.pushFormWindow("CC42.1",strPDL,vHK);
    return true;
    }
    David Williams
    Private
    Private
    Veteran Member
    (3076 points)
    Veteran Member
    Posts:1036


    Send Message:

    --
    09/17/2013 2:38 PM
    I understand. If you have ProcessFlow you can use the Portal URL Builder within the Email node to retrieve the correct syntax - since this is a custom form, I can't help you - but it would look something like:

    https://server/lawson/portal/index.htm?_PDL=TEST&_TKN=HR07.1&_HK=10001234567890

    The _HK values are the key field values you want to pass to your new form.

    Your's might look like:

    // https://zzz211.myserv.com/lawson/portal/index.htm?_PDL=DEV&_TKN=CC42.1&_HK=000137115%20%20%20%2020132

    Company is 4 characters, employee is 9 (and has to be blank %20 filled), year is 4 characters and quarter is 1 (?)
    David Williams
    wilcoxmad
    Private
    Private
    Veteran Member
    (231 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    09/18/2013 7:11 AM
    I did some research on the HKey and in the cobol (added -l to the lawcmp command) and I see this:
    4834 02 CC42F1-KEY-PROTECTED.
    4835 03 CC42F1-PT-QIC-COMPANY PIC 9(04).
    4836 03 CC42F1-PT-SUPER-EMP PIC 9(09).

    So how do I get the 4GL to recognize that I want Year and Quarter in the HKey area?
    wilcoxmad
    Private
    Private
    Veteran Member
    (231 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    09/18/2013 7:22 AM
    Nevermind, I figured it out changed the SB to SN in the "REQ" field of the .scr file.
    You are not authorized to post a reply.