if you aren't using persistent fields then ISTR you can't define calculated fields.
is it possible to pre-define a few of these calculated checkboxes (all handled by the same handler) and alter their grid visibility on the fly instead of creating them? (i don't completely understand your problem so this may be a miss) -ns http://www.roserox.co.th ----- Original Message ----- From: "Rohit Gupta" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 04:36 Subject: Re: [DUG]: Adding Calculated Field > 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/ > --------------------------------------------------------------------------- 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/
