Tip Bank

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

“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

DevX - Software Development Resource

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

DevX - Software Development Resource

Balnk form

Question: How do I open up a blank form – a form without any values displayed? Answer: As you probably know, you can add a DefaultCondition to your form, such