Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3
The problem of use CAST, is the result of the same work to convert the TIntegerFields, so as so is to much work! I cannot use SET BIND? This command really exists? Em sex., 28 de fev. de 2020 às 17:06, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escreveu: > > 28.02.2020 20:11, Roberto Vieweg jjw.roberto.fireb...@gmail.com > [firebird-support] wrote: > > 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 > >Use CAST() in failing queries. > > > -- >WBR, SD. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > >
Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3
28.02.2020 20:11, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > 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 Use CAST() in failing queries. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3
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? 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