Subject | TIBOQuery and TDBLookupComboBox |
---|---|
Author | Steve Harp |
Post date | 2006-01-09T16:41:45Z |
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
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