Tip Bank

DevX - Software Development Resource

Can’t see tables

Question: When I open a session to an Oracle database, I can’t see any tables other than those owned by my user name. How can I get access to tables

DevX - Software Development Resource

OnKey()

Question: What is the OnKey() method? Answer: The OnKey() method is a new method introduced with OPO version 1.0.16. The OnKey() method is triggered for an object whenever a user

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