Subject RE: [IBO] Bug with SELECT FIRST n SKIP n type queries
Author IBO Support List
How did you install what you are currently using?

With the installer that will be released in the next version (Build 8) it
will automatically uninstall whatever was previously installed via an
installer. If you installed things manually you can just go ahead and
install using the installer and overwrite the exact same folder so that
everything is the same. Then, from that point forward, any new install, even
to other folders, will uninstall whatever was previously installed.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Sunday, August 25, 2013 2:52 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Bug with SELECT FIRST n SKIP n type queries

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
>
>



------------------------------------

___________________________________________________________________________
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