I'm trying to add a new DBGrid column at runtime by calling the Add method
like this:

DBGrid.Columns.Add

The result is all the original columns are removed from the grid, and a new
column without a title is added.  Subsequent calls to the same Add method
result in new columns.

Question:  How do I add a new column without clearing the original columns?

Thanks,
Lito

Lito Dizon
adi...@us.net

===========================================================
 Dan Gilbert                           dgpc...@{*word*104}ia.com
             www.interlink-2000.com/dgpc001
     Wait! Don't pick up that ph*)0z^%.NO CARRIER
===========================================================

On Sun, 08 Dec 1996 21:58:49 GMT,
Dan Gilbert  <dgpc...@{*word*104}ia.com> wrote:

Thanks for your reply.  Yes, you misunderstood my question.  So let me try
again <G>.

I have a DBGrid connected to an open Query.  There are 3 columns in this
grid.  I want to add a 4th column.  It is a calculated column derived from
the original columns.  So I do a DBGrid.Columns.Add which results in the
clearing of the original 3 columns and replaced with one new empty column.  
Am I doing something wrong?

Lito

Lito Dizon
adi...@us.net

Oliver

It sounds like you don't have any columns at all defined when you open your
query.
When you display a grid without defining columns, it just uses whatever
properties
it gets from the fields in the table(s) you are displaying.  So, when you
try and define
a new column on the grid, the grid must show ALL of it's columns by using
the
properties of each Column object.  So, you can either define the first 3
columns
at design time with the property editor, OR, you can define all 4 at the
same time
in code.

  In other words, I think that if you are going to define 1 column on a
grid with the
column object, you must define them all that way....Good luck!

--Shawn Clark
scl...@illuminet.net

Angelito Dizon <adi...@mail.us.net> wrote in article
<19111.adi...@mail.us.net>...

On 10 Dec 1996 22:03:16 GMT,
Shawn Clark  <scl...@illuminet.net> wrote:

As I mentioned in my original post, there were 3 columns in the dbgrid.  
They disappeared when I did a dbgrid.columns.add.

Lito

Lito Dizon
adi...@us.net

Hi All!
May be who have documentation on Oracle SQL*Net v2
I can read any format
Please send me by E:mail

You could structure your query to include a NULL field in the recordset.
For example:
SELECT DISTINCTROW Categories.[Category ID], Categories.[Category Name],
Categories.Description, Null AS CalcdField
FROM Categories;

I don't know if this will work; just an idea.