Question: [Joe Celko’s Budget Versus Actual Puzzle]C. Conrad Cady posted a simple SQL problem on the CompuServe Gupta Forum. He has two tables, Budgeted and Actual, which describe how a
Question: [Joe Celko’s Dataflow Diagrams Puzzle]Tom Bragg posted a version of this problem on the CASE Forum on CompuServe. You have a table of dataflow diagrams (DFDs), which has the
Question: I have been having a lot of trouble with a SqlLookup() function. Whenever I use a WHERE clause, I get a parse error.The offending WHERE clause is “WHERE SW_LICENSE
Question: I want to manipulate a check box in a repeater control, but the check box is not bound to any data column. How can I do this? Answer: Every
Question: I am using the Japanese version of OPO. Occasionally, I get an error messagethat says ‘Failed to lock row.’ It doesn’t happen all the time. What makesOPO lock a
Question: I can’t seem to clear the default menus in a modal dialog box. I have triedall types of code in the OpenModal() method, but the default menusstill appear. How
Question: I am doing a select from a table where I want to combine two fields. Specifically, I have the StreetNumber andthe StreetName stored separately. I would like to beable
Question: My application is working with a fairly large database. Althoughusers will never be allowed to request all of the data, differentselection conditions may return wildly varying amounts of data.
Question: I like the automatic QBF facility that comes with all default Power Object applications. Is there any way to pass the selection criteria to a report? Answer: Yes, there