Subject Re: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED"
Author Michel LE CLEZIO
Post date 2017-07-27T15:47:25Z
Big Thank you Jason,

We will wait your next relaese... 

Have a nice day.
With Best Regards, 
Michel


Le Jeudi 27 juillet 2017 17h40, "'Jason LeRoy Wharton' jason@... [IBObjects]" <IBObjects@yahoogroups.com> a écrit :


 
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
     ( FBDataset.FSQLOrderLinks.Count > 0 ) then
  begin
    if ( FBDataset.OrderingItemNo >= 0 ) then
    begin
      if FAscending then
...
Will someone apply this change to their sources and then go to the ibo5\build folder and run the Build batch file to rebuild the binaries and then test their application again to see if this will be a quick workaround?

Where I have not been able to reproduce this yet, I'm just grasping for a solution.
Thanks,
Jason Wharton