Subject | adding a calculated field to a DBGrid |
---|---|
Author | duilio_fos |
Post date | 2002-10-14T20:01:12Z |
I use IBO3 with Delphi 3.
I want to display item IDs and item descriptions in a DBGrid.
This is easily done by constructing a TIB_Query with the following
SQL string:
'select cod_art, des_art from art order by des_art'
A Datasource links the TIB_Query to a DBGrid and voila', ev works.
Now the problem.
I want to display the existing quantity QTY for every item, aside ID
and description.
But QTY is not a table field.
QTY can only be dinamically calculated by a SP (whose name is Q_E)
that accepts an item ID and the final date for the calculation.
This beats me.
How can I do that ?
TIA
Duilio Foschi
I want to display item IDs and item descriptions in a DBGrid.
This is easily done by constructing a TIB_Query with the following
SQL string:
'select cod_art, des_art from art order by des_art'
A Datasource links the TIB_Query to a DBGrid and voila', ev works.
Now the problem.
I want to display the existing quantity QTY for every item, aside ID
and description.
But QTY is not a table field.
QTY can only be dinamically calculated by a SP (whose name is Q_E)
that accepts an item ID and the final date for the calculation.
This beats me.
How can I do that ?
TIA
Duilio Foschi