Any other suggestions.. I am really stuck here...
PROBLEM
The only solution I have is to use a calculated field at run-time. I cant define
persistent fields as the query changes depending on user input. The list from the qry
gets displayed and the user needs to deselect some rows.
If I have a calculated field linked to a checkbox - then when he presses space or dbl-
clicks on that column, I can fire a separate qry to record this in an exclusion
table....
and because its a calculated field I can refresh the display to give him immediate
feedback. if the exclusion table was joined to the query then I would have to refresh
the query which can take several minutes I would not be able to provide immediate
feedback.
The only other soultion would have been multiple inserts from an sql statement - but
that is not supported. Then I could have populated an inclusion table instead.
> How do I go about adding a calculated field to a dataset/grid at run-time ? I
> have tried various things - none of them work
>
> fielddefs.add
> fielddefs.addfielddef
> fields.add
> Regards
>
> Rohit
Regards
Rohit
=================================================================
=====
CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
PH (649) 489-2280
FX (649) 489-2290
email [EMAIL PROTECTED] or [EMAIL PROTECTED]
=================================================================
=====
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
