Answer / drew

Answer 1 is good if you don't have a lot of data to write to
the data table. I sometimes have 20 columns to write to and
to check for the column each time before writing the data
can take 2 or more seconds each (40 seconds for the entire
row)...way to long if doing a repetitive task.

Answer 3 won't work because you will get a QTP error on the
line "Val = DataTable("UserId", dtGlobalSheet)" if the
column doesn't exist. But you can use that error to make a
very speedy function to find out if the column exists:

If COM_DoesDataTableColumnExist("Global","Column1") Then
''Column Exists
Else
''Column Does Not Exist
End If

Public Function COM_DoesDataTableColumnExist(ByVal
strSheetName,ByVal strColumnName)
Dim blnReturnValue
Dim strTestColumn

Err.Clear
On Error Resume Next
strTestColumn =
DataTable.GetSheet(strSheetName).GetParameter(strColumnName).Name

If Err <> 0 Then
blnReturnValue = False
Else
blnReturnValue = True
End If
Err.Clear

COM_DoesDataTableColumnExist = blnReturnValue
End Function

Answer / ravi bandaru

Function isParameterExists(sheetName, paramName)

isParameterExists = FALSE
ParamTotal = DataTable.GetSheet("Global").GetParameterCount

For i = 1 To ParamTotal
value = DataTable.GetSheet("Global").GetParameter(i).Name
Msgbox value
If strComp(paramName,value)=0 Then
isParameterExists=TRUE
Exit Function
End if
Next
End Function
'Example:
If isParameterExists("Global","hh") then
msgbox "Patameter exists"
Else
msgbox "Patameter does not exist"

<Your statements>


End if

Answer / nani4urs

Hi ravi Please run above sript in qtp.
is it works?

Answer / garywu

Public Function existColumn(byval Sheetname,byval ColumnNum)
paramcount = DataTable.GetSheet
(Sheetname).GetParameterCount
If ColumnNum>paramcount then
existColumn=False
else
existColumn=True
End If
End Function

Answer / rajaputra

Try for this,

Val = DataTable("UserId", dtGlobalSheet)
If val=false Then
msgbox "Parameter does not exist"
Else
msgbox "Parameter exists"
End If

what is Compile Module in QTP? what exactly it contains Functions or Actions?

2 Answers   GE,

write vbscript on veb applications in qtp with exapmles?

1 Answers  

How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.

2 Answers  

Is it possible to call win runner script in qtp?

0 Answers  

How can i store runtime value through vb script while using qtp

1 Answers  

how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief

0 Answers   HCL,

how i can delete the excel process for the task manager using QTP

2 Answers  

If some requirements r changed during the testing process ,then how can u handle this in frame work?

1 Answers  

Suppose u run ur script today and it is working fine ,nobody has changed the setting and all.u r the owner for the script. But when tomorrow I ran the same script again it got failed and It didn't able to identify one object. Can you tell me what would be the reason for this

4 Answers   L&T,

How to do the scripting. Are there any inbuilt functions in QTP? What is the difference between them? How to handle script issues?

0 Answers  

General Ques : At What State u start Automating ? means at what stage we start writing QTP scripts ?

2 Answers  

i need qtp tutorial. pls send it to sridhar.k151@g mail.com

0 Answers