topic Re: Detecting if a field is defined in VBScript? in QlikView

Detecting if a field is defined in VBScript?

Fri, 29 Jun 2012 10:09:33 GMT

I'm trying to detect if a field is defined in a document in a VBScript macro but I don't see any obvious predicate or test to do so.

For example, if I retrieve a field like this:

set kaboom = ActiveDocument.Fields("DOESNOTEXIST")

Then kaboom is not null, is not empty and is an object.

So would do I test if ActiveDocument.Fields returns a real field in the document?

Thanks,

Andrew Warinner

m_woolf — Fri, 29 Jun 2012 11:10:32 GMT

Maybe you can use the system field $Field.

Fri, 29 Jun 2012 11:37:22 GMT

Yes, that looks like it will do the trick.

Thanks!