Forum Discussion

BillA603's avatar
BillA603
Contributor
11 years ago

Data-Driven Test. How to handle Tab to next control for fields that are blank

Hi,   New User here. I recorded a keyword test, then created a Data-Driven Loop. Right now just performing a few quick tests. Input data consists of client name and service begin and end dates, how...
BillA603's avatar
BillA603
Contributor
11 years ago

fyi: PowerBuilder app.

Script generated from Keyword Test [below]

 

The execution stops with Exception

Type Mismatch on the End Date step.

 

Note: I inserted line breaks in front of FNUD03110.... so code would not wrap

 

script:

 

' Enter the Bgn Date [mmddyyyy as text]

Call

Aliases.options.wndFNWND3110.MDIClient.wndFNWND311016.PBTabControl32_100.

   FNUDO3110.pbdw110.PBEDIT110.Keys(Project.Variables.LtcTest1.Value("SrvcBgnDt"))

 

' Tab to next control

Call

Aliases.options.wndFNWND3110.MDIClient.wndFNWND311016.PBTabControl32_100.

   FNUDO3110.pbdw110.PBEDIT110.Keys("[Tab]")

 

' This is where Exception gets thrown when End Date in XLS is blank 

' Enter the End Date [mmddyyyy as text]

Call

Aliases.options.wndFNWND3110.MDIClient.wndFNWND311016.PBTabControl32_100.

   FNUDO3110.pbdw110.PBEDIT1102.Keys(Project.Variables.LtcTest1.Value("SrvcEndDt"))

 

' Tab to next control

Call

Aliases.options.wndFNWND3110.MDIClient.wndFNWND311016.PBTabControl32_100.

   FNUDO3110.pbdw110.PBEDIT1102.Keys("[Tab]")

 

  • BillA603's avatar
    BillA603
    Contributor
    11 years ago

    Data:

    row 1 and row 3 run fine.

    row 2 test fails [blank end date].   

    SrvcBgnDt | SrvcEndDt

    -----------| ----------

    01012015 | 03312015

    01152015 |

    02022015 | 05312015

    • Marsha_R's avatar
      Marsha_R
      Icon for Champion Level 3 rankChampion Level 3
      11 years ago

      Blank fields in Excel have never worked for us, no matter how we formatted the field.  I suspect that there's hidden formatting that causes the type mismatch.

       

      What we ended up doing was putting some never-to-be-used character in the "empty" field and then using If Then Else

       

      If (ThingInExcel) does not equal (SpecialCharacter) Then

      (put ThingInExcel in field)

      Else

      (tab past field)

       

       

       

       

      • Andrey_M's avatar
        Andrey_M
        Contributor
        11 years ago

        Hi Marsha.

         

        Have you tried nothing for empty field check?

         

        In KDT it looks like

         

        If Variables.excelData("Field2") Equals nothing

          Log Message [...]

         

        To define nothing in KDT: select Code Expression as value type to compare to and type nothing as piece of code.

         

        This example is valid if VBS was chosen as scripting language.

         

        null works for empty Excel fields if JS used for scripting.