Original Message processed by David®

 

RE: Re-12: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (25-Jul-2017 6:59)
From:   'IBO Support List' supportlist@ibob
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

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)
From:   supportlist@... [IBObject
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