Subject RE: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED"
Author Jason LeRoy Wharton
Post date 2017-07-27T15:05:04Z

This is a confirmed bug in IBO.  It can be worked around easily, but that won’t be necessary if you apply the patched release I will be putting out today or tomorrow.

The work around is to take your affected queries and to put the ORDER BY clause of your query into the OrderingItemLinks and the OrderingItemNo property to 1.  You will end up with the same query as you had originally and you will at the same time avoid the problem of IBO thinking that you were functioning with the natural order.

 

If you can hold off a day or two, please do so in order to get my patched release.

 

Kind regards,

Jason Wharton

www.ibobjects.com

 

 

From: IBObjects@yahoogroups.com [mailto: IBObjects@yahoogroups.com ]
Sent: Thursday, July 27, 2017 7:59 AM
To: IBObjects@yahoogroups.com
Subject: Re: Re-14: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED"

 

 

Hello,

 

I will deploy an upgrade of my application with the last IBO version.

I haven't get this problem in my test...

 

Does this problem is solved or is it a problem of the code application, but not an IBO problem ?

 

I'm waiting for more information of this before to deploy my upgrade...

 

With Best Regards,

Michel

 

Le Mardi 25 juillet 2017 19h10, "'Jason LeRoy Wharton' jason@... [IBObjects]" < IBObjects@yahoogroups.com > a écrit :

 

 

Please contact me directly at Jason@... or you can find me on Skype too.

 

Jason

 

From: IBObjects@yahoogroups.com [mailto: IBObjects@yahoogroups.com ]
Sent: Monday, July 24, 2017 11:36 PM
To: IBObjects@yahoogroups.com
Subject: Re-14: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED"

 

 

hi

 

yes, of course - when? i'm in car now for 2 hours and after this you can make remote session any time  - how can we contact directly?

 

 

mit besten Grüßen aus Salzburg

 

Logo GMS


Ulrich Hutter

Programmierung und Geschäftsführung

 

 

Original Message processed by David®  

 

 

RE: Re-12: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (25-Jul-2017 6:59)

To:

 

 

I would like to do a remote support session and have a chance to debut your application directly.  Is this possible?

Thanks,

Jason Wharton

From: IBObjects@yahoogroups.com [mailto: IBObjects@yahoogroups.com ]
Sent: Sunday, July 23, 2017 4:07 AM
To: IBObjects@yahoogroups.com
Subject: Re-12: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED"




hi

did not help.

FBDataset.FSQLOrderLinks.Count  = 1

FBDataset.OrderingItemNo = 0

- so error occours again.

It is in my application very easy to reproduce

best regards

mit besten Grüßen aus Salzburg

Logo GMS


Ulrich Hutter

Programmierung und Geschäftsführung

Original Message processed by David®  

 

 

Re: Re-10: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (22-Jul-2017 16:09)

To:

 

I am in Mountain Standard Time ( Denver CO ) Timezone.

I have a possible work around that can be tried.

I'm wondering it this source patch to IB_Components.pas line 36877 adjusted as follows would fix it.

...
begin

  inherited SysPrepareSQL;

  aIsForSync := FSeqNo > 0;

  tColStr1 := FColName1;

  tColStr2 := FColName2;

  tColStr3 := FColName3;

  if ( tColStr1 <> '' ) and  // Add in a check to the FSQLOrderLinks.Count



(Message over 64 KB, truncated)