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.

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.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several