Tip Bank

Question: How can I use SQL to specify a query like the example below: select * from mytable where column like ‘a[bc]’This should match both “ab” and “ac” but not

Question: I want to periodically check to see if a user’s database connection has been lost. How can I? Answer: First of all, a solution. You can implement periodic ‘polling’

Question: I have two related tables. I need to go and update atable searching for a value I find in the second table (byjoining both tables). I wrote the following

Question: Can an OPO application act as an OLE client and use OLE automation with an OLE server? Answer: OPO Version 2.0 can act as an OLE server, but not

Question: I am using custom toolbars in my application. When I call the QBF form, ithas a default menu bar. How can I get rid of this? Answer: While the

Question: How can I set the flushing of rows to the database or the locking strategy used by Power Objects? Answer: Oracle Power Objects ‘supports’ two ways that rows can

Question: The repeater in my application seems to be very slow in populating. Is there anything I can do to improve its performance? Answer: Poor performance can be the result

Question: What are the advantages/disadvantages of putting large binary files (1+ MB) in BLOB columns versus storing them on a file server with a reference such as a directory/file spec

Question: I am trying to write a report that will bring back fiveindividual pieces of data that are stored within the same column in a table. How do I do