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