• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

Alter structure of TCientDataSet

Hi there,

I got a TClientDataSet, and I want to add another column to the table.

I tried doing this

fDB : TClientDataSet;
{ .. }
fDB.Close;
fDB.FieldDefs.Add('TypeResult', ftMemo, 0, false);
fDB.CreateDataSet;

But it blows away all my current data....

How can I add another column to the dataset without losing all the current info?
0
wildzero
Asked:
wildzero
1 Solution
 
Geert GOracle dbaCommented:
fDB.Close
clears all data

if the data comes from a query you can add it by changing the query with an extra column or a calculated field

if you manually added the data
create a new clientdataset with the extra column and copy the data from the old dataset to the new
0
 
wildzeroAuthor Commented:
Yea that is what I have had to do.
Create a new TClientDataSet and move the data over.

:-/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now