I have dealt with this before on large projects (FB 2.0 / 2.5). Its not really a big deal. Just do a (text) search through your .dfm (form/datamodule) files for the field and edit the text files to change the data type to the correct version. You can even automate the process as required. Rebuild the project and your done. Obviously this doesn't work if your dfms are binary.
Cheers Rob On 3/03/2020 12:01 am, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > I think this isn't only my "pain". > > I good solution here will be a configuration for legacy systems, like > Authentication legacy. > > Em seg., 2 de mar. de 2020 às 06:13, Mark Rotteveel > m...@lawinegevaar.nl <mailto:m...@lawinegevaar.nl> [firebird-support] > <firebird-support@yahoogroups.com > <mailto:firebird-support@yahoogroups.com>> escreveu: > > On 28-02-2020 20:11, Roberto Vieweg jjw.roberto.fireb...@gmail.com > <mailto:jjw.roberto.fireb...@gmail.com> > [firebird-support] wrote: > > Is possible to use the SET BIND feature > > > > (https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.set_bind.md) > > from Firebird 3 to remap the datatype of a count statement from > BIGINT > > to INTEGER? > > > > If yes, can you provide details and example how to do this? > > SET BIND is a new feature in Firebird 4, so you cannot use it in > Firebird 3. In Firebird 4, you can do this with `SET BIND OF > BIGINT AS > INTEGER`. > > > Ps.: I have a very big old-application written in Delphi 7, with > a lot > > of TSQLQuery with hardcoded count queries mapped to > TIntegerField. So > > is impossible to do a migration right now. I need other options.... > > You could use casts, though I'm surprised that there is no automatic > coercion within Delphi. > > Mark > -- > Mark Rotteveel > >