devxlogo

Tip Bank

Improving performance

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

BLOB Data Storage

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

Splitting Data Within a Column

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

Mail

Question: Is there a way to send mail with a mouse click? I’m working on a Mac and in Windows. Answer: You can send mail, or do virtually anything else

Dependent values

Question: I want to create a list box that will contain values based on the value ofanother list box. How can I accomplish this? Answer: A list box is populated

Inserting rows

Question: When I insert a row into a table, the results from the query that come after the row don’t show up. If I re-fetch the results, I can get

Eliminating toolbars

Question: How do I eliminate the toolbar for a form? Answer: To eliminate the toolbar from displaying for a particular form, add the code: Self.SetToolbar(NULL) to the InitializeWindow() method for

Cannot connect to Personal Oracle

Question: I have been trying to connect to Personal Oracle 7 on the Macintosh. I can connect from the DBA applications, but cannot connect from Power Objects. Can you give