Subject Re: [IBO] Bug with SELECT FIRST n SKIP n type queries
Author Robert Martin
Sweet

Glad you found it. Just wondering, what is the best method of updating
IBO. Is there a simple update process or should I uninstall & re install ?

Thanks
Rob



On 25/08/2013 5:41 p.m., IBO Support List wrote:
> Rob,
>
> Nevermind, I did finally work it out and got it to duplicate.
>
> And, I have this fixed to be included in the Build 8 release I am just
> finishing up.
>
> Sorry for the wait.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of IBO Support List
> Sent: Friday, August 23, 2013 4:01 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Bug with SELECT FIRST n SKIP n type queries
>
> Rob,
>
> I tried to get this to duplicate and I have been unable to.
> There must be something in the mix that I am not able to see.
> Will you please put together a quick little sample app for me?
>
> Thanks,
> Jason
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of IBO Support List
> Sent: Thursday, August 22, 2013 11:59 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Bug with SELECT FIRST n SKIP n type queries
>
> I'll look into this and see about slipping in a fix for build 8.
> I'm currently fighting with my installer routines again.
> I discovered I need a binary installer for the XE4 Starter Edition.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of Robert Martin
> Sent: Thursday, August 22, 2013 9:52 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Bug with SELECT FIRST n SKIP n type queries
>
> Hi
>
> Using IBOQuery. Queries like...
>
> SELECT FIRST 5 SKIP 1 fc.HistoryRef, fc.Rate, fc.LstChgDate AS EnteredDate
> FROM ForeignCurrencyHistory fc WHERE fc.CurrencyRef = 11 ORDER BY
> fc.HistoryRef DESC;
>
> Run fine but when Query.Refresh is called an ISC error occurs with 'Token
> unknown ... SELECTfc'
>
> The same query above running in an app with a DB navigator returns 'column
> unknown ... C.HISTORYREF' when the refresh button is clicked.
>
> These sort or errors appear to be true for ANY First / Skip type query.
> I also tested
>
> SELECT FIRST 5 SKIP 1 i.ItemRef
> FROM Item i
>
> Which returns either 'Token unknown ... SELECTi' OR 'column unknown .'
> depending on which way it is refreshed.
>
> tested in
>
> 5.2.0 6
>
> Thanks
> Rob
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3392 / Virus Database: 3211/6607 - Release Date: 08/25/13
>
>