Subject TIBOQuery and TDBLookupComboBox
Author Steve Harp
Hi All,

I'm trying to work with a TIBOQuery and a TDBLookupComboBox. Here's
from the dfm

object cbCategory: TDBLookupComboBox
Left = 16
Top = 49
Width = 150
Height = 21
Hint = 'Category'
DataField = 'CATEGORYID'
DataSource = DM.dsFBTmp
KeyField = 'ID'
ListField = 'Name'
ListSource = DM.dsFbCat
ParentShowHint = False
ShowHint = True
TabOrder = 1
end

When the page first displays, everything is fine and the
TDBLookupComboBox displays correctly. The problem is when I try to
move the DataSource to the next record. It should find the next item
in the ListSource and update the display of the TDBLookupComboBox.
Instead, I get the following error.

Project MyApp.Exe raised exception class EIBO_ISCError with message
'ISC ERROR CODE:335544569
ISC ERROR MESSAGE
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 16
WHERE

STATEMENT:
TIB_LocateCursor:
"<TApplication>.DM.qryFbCat.IBOqrqryFbCat.<TIB_LocateCursor>"

STATEMENT
TIBOInternalID. Process stopped. Use Step or Run to continue.

The really interesting thing is that my ListSource query doesn't have
a where clause.

DM.qryFbTmp DataSource Query:
Select *
from xTmp
Where (TmpID BETWEEN 1 AND 11)
Order by TmpID, CategoryID, NationID, DifficultID, CostID, RankID

DM.qryFbCat ListSource Query:
Select CategoryID AS ID, Name
from xCategory
order by Name;

What am I missing?

Thanks,
Steve