Automatically replacing FMTBCD Fields at Design time

devartfan · Post by **devartfan** » Mon 14 Sep 2009 14:51

Hi,

during migration from bde to dbexpress we converted all fields to fmtbcd in all our queries, stored procs and so on. In the meantime we would like to get rid of the fmtbcd-fields so we turned off the connection param EnableBcd (EnableBcd=false).

Is there a possibility to automatically replace all fmtbcd fiels at design time in the IDE? It is pretty much work to go through all data modules and do the work manually. We are looking for a tool which does the work for us (perhaps the BDE migration Wizard is a choice?)

Any hint is welcome!

Regards

Devartfan

Plash · Post by **Plash** » Tue 15 Sep 2009 09:20

You can use any text editor that supports 'Replace in Files' feature (for example, Microsoft Visual Studio). Replace TFmtBcdField with TFloatField in all your *.pas and *.dfm files.

luboice · Post by **luboice** » Tue 15 Sep 2009 09:30

Use this http://www.ecobyte.com/replacetext/ to mass replace in your *.pas and *.dfm files