Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development > Database Administration

Database Administration - Page 3

41-52 of 52     Previous     Next
Declaring type variables or composite data types
by DevX Pro
I need to be able to print results of a query to an Excel spreadsheet rather than to a report. I am using the Crystal Reports product included with Oracle Power Objects. However, it clearly states that the Crystal Reports OCX does not work with Windows 3.1, so I am using the Crystal Reports DLLs. One of the functions I need to use requires the use of a composite data type. In Visual Basic this would look like: Public Type variable-name SubVariable_Name1 as DataType SubVariable_Name2 as DataType ... End Type Unfortunately this declaration does not work for OPO. And I can find no similar method anywhere. How can I declare a composite user-defined data type in Oracle Power Objects for use in these DLL functions?
Can Crystal Reports output to MS Word?
by DevX Pro
The Crystal Reports help file contains "Pro-only Topics." Can I use these Pro features with the Crystal Reports engine I recieved with OPO? If so, where can I find an example of outputting a Word document? I am developing a work flow system for a gov. agency and would love to output and save to an Oracle database a Word Doc.
Enabling and disabling fields in a repeater
by DevX Pro
Is there a way to enable and disable fields inside a repeater display depending on the values of fields on the master form? I have tried it various ways (on the master form, on the repeater) but I have got the always present "Repeater controls can oly be used with agregation functions."
Check box in a repeater
by DevX Pro
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?
Flushing and Locking
by DevX Pro
How can I set the flushing of rows to the database or the locking strategy used by Power Objects?
Improving performance
by DevX Pro
The repeater in my application seems to be very slow in populating. Is there anything I can do to improve its performance?
Selecting multiple rows
by DevX Pro
I want to let the user select more than one row in a repeater so my application can act on all of them at one time?
Set focus
by DevX Pro
When a user selects a value from a list box, I populate the contents of a repeater. I also want to set the focus into the repeater's first field. How can I accomplish this?
How do I achieve consistent data retrieval performance?
by DevX Pro
My application is working with a fairly large database. Although users will never be allowed to request all of the data, different selection conditions may return wildly varying amounts of data. I'm worried that the performance of the data retrieval may be inconsistent, based on how much data is retrieved from a particular user request.
How do I limit the rows retrieved for a Power Objects report?
by DevX Pro
How do I limit the rows retrieved for a Power Objects report?
I want to retrieve data from a database that is not associated with any objects
by DevX Pro
I want to retrieve data from a database that is not associated with any objects on a form. How do I do this?
Inserting rows without retrieving data
by DevX Pro
I have a very large table that contains thousands of rows. I want to let a user insert new rows into it on a particular form without having to query the table. How can I create a recordset that is bound to a table and session so that I can quickly insert the row and then close the recordset?
41-52 of 52     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date