Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: SQL
Expertise: Beginner
Jul 23, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Declaring type variables or composite data types

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?

I'm pretty sure you can't declare a composite data type in Power Objects. However, if I wanted to save the data from a query to a spreadsheet, I'd use the ODBC driver for Excel, open a spreadsheet as a data source and just do simple INSERTs to the spreadsheet.

This should work, although I have not tried it.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date