Page 1 of 1

Edit multiple fields simultaneously.

Posted: 19.05.2009, 15:47
by Kinthamen
What I am looking for is a way to search for a word and change the word in all fields with it simultaneously. Like the find/replace in word.

Posted: 19.05.2009, 19:41
by trupka
IMHO, it's database specific problem and can't be done in "generic" way - this must be done on client side. If you need nice search/replace functions for delphi, take look on TRegExpr library here: http://regexpstudio.com/TRegExpr/TRegExpr.html

Posted: 19.05.2009, 20:58
by mdaems
You 'could' write an extension to the zeoslib TZAbstractRODataset class and implement a new function for this job. There you could add some loop through all resultset fields to do the real work immediately on the internal data level.

Don't expect we add it to the standard zeoslib distribution, however. That's not what a database connectivity component suite is made for.

Mark

Thank you

Posted: 20.05.2009, 00:07
by Kinthamen
Thank you for the quick replies. I really didnt expect a reply this soon. I will try what you suggest. Thank you!