devxlogo

Tip Bank

Dataflow Diagrams

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

SQL parsing error

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

Check box in a repeater

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

Lock failure

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

Clearing menu bars

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

Combining Columns of Different Types

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

Join Performance

Question: I’m wondering whether it would be faster to join a large table to a small table by placing the large table on the left side or theright side of

Client-Server Architecture

Question: I’ve heard a lot of talk about “client-server architecture” ? is it something real, or just marketing hype? Answer: Indeed, client-server architecture is real. Put simply, the client-server model

“Null” method

Question: I want to be able to start a section of code if nothing is happening in an application. This type of ‘null’ method is useful for default tasks. How