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