Need help - validating data

• Question

• 

  

  0

  Sign in to vote

  Need help to add some validations to this below script.

  Eg: If I write a database query, want to validate the result. Plz help..

  *****************

  #$language = "VBScript"
  #$interface = "1.0"
  
  crt.Screen.Synchronous = True
  
  ' This automatically generated script may need to be
  ' edited in order to work correctly.
  
  Sub Main
      crt.Screen.Send "sqlplus" & chr(13)
      crt.Screen.WaitForString "Enter user-name: "
      crt.Screen.Send "test" & chr(13)
      crt.Screen.WaitForString "Enter password: "
      crt.Screen.Send "testpwd" & chr(13)
      crt.Screen.WaitForString "SQL> "
      crt.Screen.Send chr(13)
      crt.Screen.WaitForString "SQL> "
      crt.Screen.Send "set lines 300" & chr(13)
      crt.Screen.WaitForString "SQL> "
      crt.Screen.Send "set pages 300" & chr(13)
      crt.Screen.WaitForString "SQL> "
      crt.Screen.Send chr(13)
  End Sub
  

  ---

  Rajendra

  Monday, January 24, 2011 10:29 AM