Subject | Bug with SELECT FIRST n SKIP n type queries |
---|---|
Author | Robert Martin |
Post date | 2013-08-23T03:51:44Z |
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
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