devxlogo

ODBC/Oracle Lite tables

ODBC/Oracle Lite tables

Question:
In OPO v1.0, it was impossible to redefine a table in a BLAZE database. I assumed this would not be the case with an Oracle Lite database and OPO v2.0. However, to my displeasure, it seems I still cannot redefine a table — I get various ODBC errors. Am I again stuck with re-creating my entire database when I want to change a field, or is the problem with ODBC?

Answer:
I don’t believe you can add a column to an existing Personal Oracle Litedatabase table. If you want to add a column, you will have to recreate thetable— not the database — from scratch.

It’s not the greatest solution, but it emphasizes the fact that you should spend sometime planning and designing your database tables at the very beginning ofcreating an application. The database design is the foundation of yourapplication system, and no system can stand firm on a shaky foundation.

See also  Small Business Strategies with Venmo
devxblackblue

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