Forum Discussion

DainiusA's avatar
DainiusA
Contributor
4 years ago

Press numbers on a Windows form app from SQL query

Hello everyone,   Not sure how to explain as simple as possible. So I have this kind of Windows form app buttons. and I have an SQL query which returns me some kind of numbers. Is it possible someh...
  • AlexKaras's avatar
    AlexKaras
    4 years ago

    HI Dainius,

     

    Actual implementation depends on the data returned from the query and how you NameMapped buttons.

    Assuming that:

    -- Query returned string value; and

    -- Buttons are NameMapped as Button1, Button2, ...

     

    below is a sample untested pseudo-code:

    var strQueryValue = <valueFromQuery>; // e.g. '12345'

    for (var i = 0; i < strQueryValue.length; i++)

    {

      eval('Button' + strQueryValue.charAt(i)).Click(); // this will click Button1, Button2, ...

      aqUtils.Delay(500); // short safety delay

    }

    ...

     

ebarbera's avatar
ebarbera
Staff
4 years ago

Hello - 

 

Yes, this is possible. First you would store the SQL query into a variable - then you may have to split it into separate integers and store them into variables. Then create a generic object in the NameMapping that uses the variable as one of the properties to identify the button it its clicking on.

  • DainiusA's avatar
    DainiusA
    Contributor
    4 years ago

    Ok I am quite new to this.

    I have made a variable for SQL query that fetches the numbers I need.

    And I have mapped all of the Windows form buttons separately in the NameMapping editor.

     

    Now comes for me the difficult part for me - "then you may have to split it into separate integers and store them into variables"

     

    Could you explain me a little bit more simplified this part ?

     

    Best regards,

    Dainius

    • AlexKaras's avatar
      AlexKaras
      Champion Level 3
      4 years ago

      HI Dainius,

       

      Actual implementation depends on the data returned from the query and how you NameMapped buttons.

      Assuming that:

      -- Query returned string value; and

      -- Buttons are NameMapped as Button1, Button2, ...

       

      below is a sample untested pseudo-code:

      var strQueryValue = <valueFromQuery>; // e.g. '12345'

      for (var i = 0; i < strQueryValue.length; i++)

      {

        eval('Button' + strQueryValue.charAt(i)).Click(); // this will click Button1, Button2, ...

        aqUtils.Delay(500); // short safety delay

      }

      ...