OPO 2.0 and mathematic operations

OPO 2.0 and mathematic operations

Yesterday I received a description for a reality problem I must represent in my OPO-database application. It concerns the drinking water supply for a city, and the staff of the water company are still working the Excel tables. Their task is to calculate, on the basis of these tables, the quality of the water they supply. The idea they have (and the work for me) is to import/implement these Excel tables (approximately 10 different ones) in the local database of OPO (Personal Oracle Lite), then develop an application that offers the user an interface (several forms) for analyzing the underlying data.

My main task will be to combine differentdata fields of tables with the help of basic mathematic or statistic operations, e.g. squaring of numbers.

In which way is it possible to implement these operations &#151 perhaps on the basis of basic mathematic operators &#151 in OPO 2.0? Maybe with the help of “methods” ? Can I find this information in your book, or perhaps you have another source of info? Are there any restrictions regarding the use of mathematic/statistic operations in OPO?

What is the easiest way to import Excel tables in “Lite”? I have a choice between Excel files and ASCII files. Which isbetter?

Oracle Power Objects includes most basic mathematical operations. If squaringnumbers is the most complex you will get, you can certainly do it in OPO.You can create user-defined methods to handle the calculation and return aresult. If you are going to use a calculation throughout your application,I would suggest defining it at the application level to make referencing iteasier.

See also  How HealthStream Learning Center Supports Healthcare Education and Compliance

If you want to do more complex operations, it might be worth your while tocreate a Dynamic Link Library (DLL) in C, because C routines generallyperform complex calculations much faster than any 4GL (like OPO). Once youcreate your DLL, you can define the functions in the Declarationssection of the application and call the function just like any other built-in OPOmethod.


About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist