Subject RE: [IBO] IBO4 & Infopower3
Author Jason Wharton
This seems like a problem simply with how the SELECT statement is
configured. You could probably reproduce this error with or without
InfoPower. We will need more details to understand better how to help you.
My guess is you need to show us how the SELECT statement is setup as well as
run the SQLTrace monitor and show us the actual SELECT statement that is
being put together that is failing.

Jason Wharton

> -----Original Message-----
> From: []On
> Behalf Of stevenggibb
> Sent: Friday, July 08, 2005 5:42 PM
> To:
> Subject: [IBO] IBO4 & Infopower3
> For several years I have been providing maintenance, and enhancements
> for software for a client. The applications were written several
> years ago using Delphi 5, InfoPower 3 and IBO 3.x. On a separate PC,
> I provide support for applications written with Delphi 5, InfoPower
> 3 and IBO 4.x Most of the code in all of these applications has been
> stable for some time. Because of the age of my development machines,
> I need to transfer my development environment for both old machines
> to a new machine. I decided use IBO 4 for all applications. This has
> caused a problem. I use the InfoPower component TwwDBLookupCombo at
> several places in one application (originally compiled with the IBO 3
> library) accessing various different tables to select lookup values
> for fields. The query component is TwwIBOQuery which seems to work
> fine with the IBO 4 library except in connection with the
> TwwDBLookupCombo. Both querys components lined in the
> TwwDBLookupCombo are opened when the form is created and no error
> occurs at that time. The error does not occur until clicking on the
> TwwDBLookupCombo component to open the dropdown list. All of the
> TwwDBLookupCombo components fail at this point when using the IBO 4
> library but will work without error if the compiled with the IBO 3
> library.
> The error dialog contains the following text:
> ISC ERROR CODE:335544569
> Dynamic SQL Error
> SQL error code= -104
> Token unknown - line 1, char 21
> TIB_LocateCursor:
> "<TApplication>.MainForm.dmGOCCP.qryLookupContact.IBOqrqryLookupContac
> t.<TIB_LocateCursor>."
> At this point I am not sure how to proceed. Is there any
> incompatibility problem using InfoPower 3 and IBO 4? Any suggestions
> would be most welcome.