PowerObjects - HELP!

From: Tom Cooke <Tom_at_tomcooke.demon.co.uk>
Date: 1996/01/04
Message-ID: <820776317snz_at_tomcooke.demon.co.uk>#1/1


This is probably quite simple, but is one of those frustrating things that hold you up when you're first starting with a new language. I'm trying to set up a query condition to use with the QueryWhere() method, and the object of the exercise is to return only those rows where the value of a column is equal to the literal value of a non-database field on the current form. I'm obviously doing something wrong, as the commonest error I get is "<formname>.<field>.Value is not a valid column name". I've tried putting quotes round things (using chr(34), as I couldn't figure out a way of embedding quotes in strings yet), but this either makes no difference or - oddly - I get an error telling me that my string literal, quotes and all, isn't a valid column name. Any ideas, anyone? While I'm on the subject, is there an easy way to make Power Objects behave like Forms(3/4/4.5) i.e. let the user put the whole form into query mode? I've tried Query-By-Form, but don't like it much. An interesting "feature" also of QBF is that if your form has a check box, QBF will only return rows with the value of the check box in the query form; I haven't found a way of telling it "I haven't typed anything in here, so I don't care what value it is, just like the other fields". Again, if anyone knows a way around this, I'd be grateful to hear.

-- 
Tom Cooke
Received on Thu Jan 04 1996 - 00:00:00 CET

Original text of this message