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 [firebird-support] <firebird-support@yahoogroups.com> escreveu: > > > On 28-02-2020 20:11, Roberto Vieweg 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 > >