Published on System iNetwork (http://systeminetwork.com)
Entering Blank Parameters with QMQry
By tzura
Created Aug 15 2002 - 04:00

Q: I've written a QMQry query that uses parameters to select certain records. I'm trying to select records where one of the fields is blank. However, when I'm prompted for the parameters and I press Enter to continue, the query fails. Can I pass a blank parameter to QMQry?

A: Yes, you can pass a blank parameter value to QMQry. Rather than simply pressing Enter, enclose a single blank within parentheses when prompted for the value and then press Enter.

Copyright © Penton Media

Source URL: http://systeminetwork.com/node/60717