Posted Fri, 14 Aug 2020 15:21:39 GMT by Steve Shriver Application Specialist
What is the proper syntax to test for an empty result when using VB Script in a workflow after looking up a value in a File Cabinet or external data source?

For example, Using a file cabinet lookup that should return VendorName, then updating an index value of the document with Iif().

So should I use

Iif(GV_VendorName = Nothing, "No Match Found", GV_VendorName)

or

Iif(GV_VendorName = "", "No Match Found", GV_VendorName)

or are these statements equivalent?

Any and all clues appreciated,
Posted Fri, 14 Aug 2020 19:13:57 GMT by Jon Weston File IT Solutions Sr Application Developer, RIM specialist
Based on advice from DocuWare techs a couple of years ago I use both of those, GV_VendorName = Nothing OR GV_VendorName = "", that way my bases are covered

You must be signed in to post in this forum.