VBScript Tutorial
VBScript Fundamentals & Features
Comments
To make the code readable
To make the code disable from execution
Data Types
Implicit Declaration of Data Types
Only data type is Variant, VBScript condiders data sub types based on usage of data.
Check Data sub types using VarType Function
Data conversion using Conversion functions
Variables
a Scalar Variables
b Array Variables
Dictionary object is equivalent to Associated Arrays / Hash variables in Perl Script
Constants
Built-in constants
User defined Constants
Operators
Arithmetic
Comparison
Logical
Concatenation operators
Conditional statements
1 If statement
2 Select Case
Usage of Conditional statements in UFT Test Automation
1 To insert verification points
2 For Error handling
Loop Statements
1 For...Next
2 While...Wend
3 Do While / Until...Loop
4 For Each...Next
Functions
What is a Function?
It is a Reusable code
Built-in Functions
Array Functions, String Functions, Date & Time Functions, Conversion Functions, I/O Functions, Math Functions and Miscellaneous Functions
User defined functions
Sub Procedures Public Internal, External Function, Private
Function Procedures Public Internal, External Function, Private
Coding conventions
Writing comments
Declarations
Dim city, num, x
With coding standards
Dim strcity, intnum, objx
Regular Expressions
It is a formula for matching patterns
Usage of Regular Expressions in UFT
a To handle dynamic objects
b For search operations
Regular expression Object
File System Operations
What is Computer File System?
Examples for File System Operations
Create a folder
Copy a folder
Delete a folder
Create a text file
write data
Read data
Compare data
Search for data
Delete a text file etc...
How end user performs File System Operations
How to perform automatic File System Operations using VBScript
Using File System Object
Object
Property
Method / Operation
Create Automation Object
Syntax:
Set Variable = CreateObject "ClassValue"
Set - VBScript statemet
CreateObject - Built-in Function
Class value for creating File System Object "Scripting.FileSystemObject"
Excel Application Object
Excel Application
Excel File / Excel Work Book
Excel Sheet / Excel Work sheet
It is used to automate Excel Application Operations
Create Excel
Take Row Count
Take Column count
Read data
Write data
Compare data etc...
Class value for creating Excel Application Object "Excel.Application"
Word Application Object
It is used to automate Word Application Operations
Class value for creating Word Application Object "Word.Application"
Database Operations
a Database Connection Object
It is used to connect to Databases
Class value for creating Database Connection Object "Adodb.Connection"
b Database Recordset object
It is used to perform operations on Database Tables /Records
Class value for creating Database Recordset Object "adodb.Recordset"
Dictionary object
It is used to define Key, value pairs
Class value for creating Dictionary object "Scripting.Dictionary"
Error Handling
Handling expected and unexpected errors
Using Conditional statements and Exist property
Using some Built-in Functions
Using Option Explicit statement
Using Exit Statement
Using On Error Resume Next statement
Nesta página do site você pode assistir ao vídeo on-line VBScript Tutorial duração online em boa qualidade , que foi baixado pelo usuário G C Reddy Software Testing 19 Outubro 2014, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 11,638 vezes e gostou 23 espectadores. Boa visualização!
