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

Think I ended up installing manually (Did it lots of times son not 100%
sure). Will give the next installer a go :0

Thanks
Rob

On 26/08/2013 9:44 a.m., IBO Support List wrote:
> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>