Looking for proper syntax 1

[Bluejay07]

Hello,

I am trying to run a COMAPI query on order entry, although I keep getting a criteria error.

OEORDD.Browse "ORDUNIQ = " & OEORDH.Fields("ORDUNIQ").Value & " AND QTYBACKORD > 0 AND LASTINVNUM <> """"", True

Could someone please provide the correct syntax for browsing the data without a blank lastinvnum field.

Thanks.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[ettienne]

Try
LASTINVNUM > """"
it's never going to be less than "".

 

[Bluejay07]

Thanks ettienne but with 4 quotation marks, the statement is incorrect and with five I still get a criteria error. Why would you suggest greater than an empty string compared to not equal to an empty string?

If at first you don't succeed, then sky diving wasn't meant for you!

 

[Bluejay07]

The problem still exists but I was doing too many things at once. The statement should actually be:

OEORDH.Browse "COMPLETE < 3 AND LASTINVNUM <> """"", True

If at first you don't succeed, then sky diving wasn't meant for you!

 

[ettienne]

It's never going to be less than "", right?

 

[Bluejay07]

Ok, so the following works:

LASTINVNUM > """""

I've never heard of comparing a string to greater than nothing but it does seem to work. I guess that is my learned lesson for the day. Thank you.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[ettienne]

Simply put: anything > nothing

 

[DjangMan]

Sometimes it's easier on the brain to write your query with an extra space, like this:

OEORDH.Browse "COMPLETE < 3 AND LASTINVNUM <> """" ", True

 

[Bluejay07]

Thanks for that suggestion as well DjangMan. I'll have to remember that.

If at first you don't succeed, then sky diving wasn't meant for you!