At 04:41 PM 9/01/2006 +0000, you wrote:

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

No; but the lookupcombo generates a where clause for qryFbCat to find the
match between the next record's KeyField column and the qryFbCat set's
Datafield. What it *should* result in is something like the following:

Select CategoryID AS ID, Name
from xCategory
where ID = :qryFbTmpCategoryID
order by Name

Now, it's possible some parsing error internally is making it something
like the following instead:

Select CategoryID AS ID, Name
from xCategory
order by Name
where ID = :qryFbTmpCategoryID

Put an IB_MonitorDialog in there to check what's actually happening.

Also, remove the semicolons from the ends of your SELECT statements. The
semicolon terminator isn't valid in DSQL and it *might* be causing the
parser to get things messed up.

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

Another possibiity is that the exception isn't related to the lookupcombo
at all, but to another relationship that involves the qryFbTemp set. Do
you have a master-detail relationship defined between the qryFbTmp set and
some other set, where the qryFbTmp set is the detail? Your WHERE criterion
would cause this error if so...

Helen