How to set a value for a null value in a function in QTP

Thread Rating:

Thread Modes

How to set a value for a null value in a function in QTP

jsknight1969 Offline

Member

Posts: 128
Threads: 9
Joined: Oct 2009
Reputation: 0

09-08-2010, 08:50 PM

Assuming you are using a recordset. You probably need to do this:

Code:
if RS.bof then

'no records

else

'do something

end if

Database queries (recordset) return a BOF (beginning of file) if there are no rows.

Hope that helps.

Find

« Next Oldest | Next Newest »

Messages In This Thread

RE: How to set a value for a null value in a function in QTP - by jsknight1969 - 09-08-2010, 08:50 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Calling a function in a Test Script from a function library	anupam4j	3	6,848	06-26-2015, 12:31 AM Last Post: babu123
	Webfile.set is not working in QTP 11 for chrome browser version 24	pradeep singh	1	5,516	11-05-2014, 11:51 AM Last Post: mansoor.s.shaikh
	how to remove null values in array	venkatesh9032	0	3,149	02-19-2014, 06:51 PM Last Post: venkatesh9032
	QTP Report to respective QC test Set Path through VBS	Anand Saboo	0	2,702	11-01-2013, 02:36 PM Last Post: Anand Saboo
	QTP unexpectedly closes itself on function "Set"	mlo	1	2,500	04-04-2013, 04:51 PM Last Post: Ankesh

Users browsing this thread: 1 Guest(s)