Solved

Insert a new field in a paradox table during runtime.

Posted on 2003-11-10
6
437 Views
Last Modified: 2010-04-05
Hi all,

I want to insert a new field in a paradox table during runtime, without loosing any data in the table.
Can anyone help me?
0
Comment
Question by:svenj
  • 3
  • 3
6 Comments
 
LVL 7

Expert Comment

by:jconde
ID: 9715934
What about using a query to do so ?

ALTER TABLE "paradox_table.db" ADD [column_name] data_type

where data_type is one of the following:

alpha, number, money, short, long integer, BCD, date, time, timestamp, memo, formatted memo, graphic, OLE, logical, autoincrement, binary, and bytes
0
 
LVL 7

Expert Comment

by:jconde
ID: 9716071
procedure TForm1.Button1Click(Sender: TObject);
begin
  Query1.SQL.Text := 'ALTER TABLE customer ADD myfield char(40)';
  Query1.ExecSQL;
end;
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 500 total points
ID: 9716351
yep,
this would be the easiest, what jconde provides

you can also use the bde-api
see
http://info.borland.com/devsupport/bde/bdeapiex/dbidorestructure.html

example 10

meikl ;-)
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 27

Expert Comment

by:kretzschmar
ID: 9721100
jconde, i post a q for you, watch out
0
 
LVL 7

Expert Comment

by:jconde
ID: 9722090
Meikl,

Thanks, but why did you do that ?
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 9722165
>Thanks, but why did you do that ?

because your suggestion is correct and was first,
so i think, its fair that you get also some points

go
http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_20794091.html

and post a comment there

meikl ;-)
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Path  to current project in Delphi. 2 79
Print Graphic and Text to Epson TM-T88v 12 257
Delphi inherited method 6 70
How to load 2 images in same column in Delphi 2 47
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question