At 07:16 AM 2/1/2008, Jim Belisle wrote:
We just purchased 7.6. I will be in the process of converting many items over the next few months. I am working on some reports now and the where builder is not working. I can type in the where clauses just fine but double clicking on the appropriate column names does not bring the columns down to the where builder nor does using the 'add' button work. What might be happening?
Jim, What results do you get when using the same scenario on RRBYW14 database? In your case, verify the IDQUOTES settings for your database. Here's how: After connecting your database, at the R> prompt: SHOW CHARACTERS Notice the last item on the list for IDQUOTES. If IDQUOTES setting is NULL, change to '`' single reversed quote. SET IDQUOTES=` Then, try the following command at the R> prompt: CHOOSE vWhereClause FROM #WHERE IN yourtableviewname Hope that helps! Very Best R:egards, Razzak.
