SQL search finding no match in DB and fails

[bry0n]

Hello everyone,

I am trying to do a database search that takes a number in text format and compares it to the serialnumber column in the DB (which is in text format).  Up to this point it works fine if the numbers match, but when I enter a number that is not in the database, an error 91 will result.   What I want it to do is to let the user whether or not there is a match in the database.  Any ideas? 

[Dennis_Knutson]

If error 91 is consistent with no match, then just use a comparison of that. You can unbundle the error cluster to get the error code.

[bry0n]

If I do that would it prevent the error from stopping the program?

[Dennis_Knutson]

If you are using the error in/error out connections, there is no reason that your program should be stopping. You have automatic error handling turned on and don't have the error clusters wired up.