devxlogo

Tip Bank

Date format

Question: My application (RIS) converts a date in an integer to store it in a Database. Integer = x seconds after 1.1.1970 (for ex., 709444800). I want to make a

Using views to improve performance

Question: We are building a Web-based interface for an existing database. We’reusing a SQL interpreter that runs the queries, then sends them to theserver without the need for a client

How can I write to OS files from Oracle?

Question: How can I write to OS files from Oracle? Answer: Oracle version 7.3 supports directreading and writing of operating system files from within Oracle.In particular, the utl_file package enables

Datawindow bands problem

Question: Occasionally I have found that after creating an executable, the bands in some of my datawindows have been repositioned to the top of that particular datawindow, causing a blank

Can Crystal Reports output to MS Word?

Question: 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

Field-level and interfield validations

Question: Field-level validations should be done when the user visits the field. How can this be done?Interfield validations on the same screen also should be done when the user visits