Subject Re: Re-14: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED"
Author Michel LE CLEZIO
Post date 2017-07-27T13:59:22Z
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:
IBObjects@yahoogroups.com
 
 
I would like to do a remote support session and have a chance to debut your application directly.  Is this possible?
Thanks,
Jason Wharton
www.ibobjects.com
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:
IBObjects@yahoogroups.com
 
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
www.ibobjects.com