What is the Progess ISNULL syntax

Posted by Admin on 31-Jul-2011 20:55

Hi Guys,

No doubt simple for you but its bugging me so I would very much appreciate your assistance

To find any ‘Nulls’ in a logial argument I use the following
If
APInvDtl.UnitCost < 0.01
Then Yes
Else No
It suits this requirement ok but naturally I would prefer to use the correct syntax if possible
Thank You
Bill

Community Groups - Forum

All Replies

Posted by maximmonin on 01-Aug-2011 02:19

APInvDtl.UnitCost = ?

Posted by Admin on 01-Aug-2011 18:22

I marked this as correct because it clearly is.

Unfortunately I had already tried this but it did not work correctly where I am trying to use it.

Using

(Epicor/Vantage 8.03.409C Open Edge 101B)

Vantage has a Query writing capability (BAQ) that requires Progess Syntax

If used ? & run "Analyze" I get Syntax error message.

If I used '?' instead of ? & run "Analyze" I get a message that the Syntax is ok but it still errors when r

This has at least help confirm there is a issue with the program

Perhaps a bug (with the BAQ)

Will pass to Epicor

Anyway,

Very much appreciate your time & assistance

Bill 

This thread is closed