Entering Blank Parameters with QMQry

Article ID: 15029

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.

ProVIP Sponsors

ProVIP Sponsors