Extracting values from a dbgrid row by row

mck...@yahoo.com (Scott)

Delphi Developer

Sun, 09 Jan 2005 16:41:28 GMT

Extracting values from a dbgrid row by row

Hi

I have a single column of values in a dbgrid which have been extracted
from a larger table using an sql query component. I was just wondering
if there is a way to take values row by row from the one column dbgrid
and if somebody could tell me how. Im using D5 Pro.

Scott

Valérie Labonn

Delphi Developer

Sun, 09 Jan 2005 22:31:34 GMT

Re:Extracting values from a dbgrid row by row

You must use the query component which is attached to the dbgrid. You
must not use the dbgrid component. Here is the code:

procedure get_values;
var
value1:string;
begin
Query.first;
while not query.eof do begin
value1:=query.fields.fields[0].asstring;
//process value1
query.next;
end;
end;

Quote

Scott wrote:
> Hi

> I have a single column of values in a dbgrid which have been extracted
> from a larger table using an sql query component. I was just wondering
> if there is a way to take values row by row from the one column dbgrid
> and if somebody could tell me how. Im using D5 Pro.

> Scott

Scot

Delphi Developer

Mon, 10 Jan 2005 18:28:03 GMT

Re:Extracting values from a dbgrid row by row

I used it with the code I had and it worked!
Thanks!

Quote

Valrie Labonne <s...@caramail.comm> wrote in message <news:3D3EBA46.6030807@caramail.comm>...
> You must use the query component which is attached to the dbgrid. You
> must not use the dbgrid component. Here is the code:

> procedure get_values;
> var
> value1:string;
> begin
> Query.first;
> while not query.eof do begin
> value1:=query.fields.fields[0].asstring;
> //process value1
> query.next;
> end;
> end;

> Scott wrote:

> > Hi

> > I have a single column of values in a dbgrid which have been extracted
> > from a larger table using an sql query component. I was just wondering
> > if there is a way to take values row by row from the one column dbgrid
> > and if somebody could tell me how. Im using D5 Pro.

> > Scott

Other Threads

1. Retrieving all row values from selected row in DBGrid

2. row in dataset from row in dbgrid

3. How to select a row in DBGrid(for row drag drop)

4. Row handle referred to a deleted row or a row marked for deletion

5. Row handle referred to a deleted row or a row marked for deletion

6. Retrieving a value in a DBGrid cell on the same row as SelectedField

7. Setting color of a row in DBGrid based on the value in a column

8. dbGrid ::: How to change row color according to some data value in table

9. how to access value in specific cell in selected row of DBGrid

10. click on DBGrid display the current row value..