dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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
Apr 1, 1997

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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 Lite database table. If you want to add a column, you will have to recreate the table-- not the database -- from scratch.

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

DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date