Source language: Translate to:

Query with "No matching Records Found"

Questions about NeoBook PlugIns

Moderator: Neosoft Support

Query with "No matching Records Found"

Postby stevec » Thu Aug 09, 2007 9:46 am

Thanks for the reply.

Just another small inquiry;

Is there a way to supress the "No Matching records found" dialog box.

For example, if I select the date, and then it queries the database, and finds no Windows 2000 systems, it pops up with the above dialog box and places the number of records into the count box?

Can you supress this and have it default to 0?

Thanks;
SteveC
Steve Christensen
stevec
 
Posts: 223
Joined: Fri Apr 15, 2005 7:33 am
Location: Boise, Idaho

Postby Neosoft Support » Thu Aug 09, 2007 2:53 pm

You can turn off the error messages including "No Matching records found" using the following action:

dbfShowErrors "False"

When error messages are turned off, you can use the global variable [dbfQueryResult] to determine if the query was successful. [dbfQueryResult] will contain the number of records found during the most recent query. For example:

dbfQuery "sample.dbf" "City=Pittsburgh AND LastName=Jones"
If "[dbfQueryResult]" ">" "0"
AlertBox "Hello" "I found [dbfQueryResult] records."
Else
AlertBox "Hello" "I didn't find any records."
EndIf
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to PlugIn Discussions

Who is online

Users browsing this forum: No registered users and 1 guest