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

Inserting a Column in a DataGrid

I want to insert a numeric column in a Data Grid, amung the table's defined fields.

The column's user input values will be used for calculations.

My attempts have achived the insertion of a column, by adding a NEW FIELD to the ADOQuery control, giving it a TYPE of 'integer' and selecting 'Calculated' for FIELD TYPE.

But the application wont allow for the manual input of values into its cells, which is what I want.

How do I do this?
0
ziche
Asked:
ziche
1 Solution
 
shaneholmesCommented:
Calculated fields are just that, calculated. They do not exist physically.

You will have to physically add a new column to your table

1.) Using the maintenance app of your desired database
2.) by runtime code
3.) SQL

What database are you using?

Shane

0
 
zicheAuthor Commented:
Im using an Access db connected to my application using ADO controls.

How exactly do I go about doing the 3 points you have suggested?
0
 
ThoseBugCommented:
Just in your ADO query....
select
 Field1,
 field 2,
 Int_Field_Created
from your_Table

and add all fields (double click into ADOQuery component) then set Int_FieldCreated readonly to false.....now aasign the adoquery to dataset and a DBGIRD to dataset ...that's all....


TB
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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