PxPlus User Forum

Twitter Twitter Twitter

Author Topic: PxPlus 2018 closing when trying to use key number 17  (Read 857 times)

Sebastiaan Fisscher

  • Silver Member
  • ***
  • Posts: 23
    • View Profile
    • Astecom Business Software
PxPlus 2018 closing when trying to use key number 17
« on: August 01, 2018, 07:47:04 AM »
I have a database file with 17 keys. If I try to go through a select --> next record with the 17th key PxPlus 2018 just closes down without a single message. If I try the same code on PxPlus 2017 then the program runs fine ...

Is there some parameter I need to set in order for it to work with PxPlus 2018?

Devon Austen

  • Staff
  • Diamond Member
  • *****
  • Posts: 257
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: PxPlus 2018 closing when trying to use key number 17
« Reply #1 on: August 01, 2018, 09:12:15 AM »
If PxPlus 2018 is closing without warning that means it or a library it has called has crashed. Since you are using a SELECT on a external database when it happens I suspect there is an issue with the optimized SELECT logic in PxPlus 2018.

I suggest you create a support ticket for this issue.

I also suggest that you include in the support ticket:
  • Info about what external database you are connecting to.
  • What PxPlus interface are you using to connect to it i.e. [ODB], [ADO], etc.
  • A description of the table and keys you are doing the select on, maybe even a CREATE TABLE directive for the table if possible.
  • The SELECT code it crashes on.
 
Software Developer for PVX Plus Technologies LTD.

James Zukowski

  • Diamond Member
  • *****
  • Posts: 155
    • View Profile
Re: PxPlus 2018 closing when trying to use key number 17
« Reply #2 on: August 01, 2018, 09:47:20 AM »
If I recall correctly, PxPlus keyed files only support 16 keys.
James Zukowski
Programmer / ERP Analyst
Beauty Enterprises, Inc.
150 Meadow St.
Hartford, CT 06114
860.296.9303  Ext 231

Devon Austen

  • Staff
  • Diamond Member
  • *****
  • Posts: 257
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: PxPlus 2018 closing when trying to use key number 17
« Reply #3 on: August 01, 2018, 10:06:08 AM »
I don't think he is using PxPlus data files so the limit of 16 keys may not apply even if it did it should return an error and not crash. He also mentioned it worked in PxPlus 2017.

As a temp workaround turning on the system parameter '!O' may avoid the issue by turning off the recent optimizations on external DB selects.
Software Developer for PVX Plus Technologies LTD.

Sebastiaan Fisscher

  • Silver Member
  • ***
  • Posts: 23
    • View Profile
    • Astecom Business Software
Re: PxPlus 2018 closing when trying to use key number 17
« Reply #4 on: August 02, 2018, 02:37:03 AM »
I am using a PxPlus EFF database. It's also not he key itself, I have removed a couple of keys for testing
Because of the attachments restrictions on this forum I can't give you a screencapture of what happens.

The process just dies without any error message from windows or PxPlus 2018.
While using PxPlus 2017 the program performs fine and as intended.

*Edit--------------------
I filed the ticket under #849795. I attached a screen capture of the behavior of the program and an image of the keydef.
« Last Edit: August 02, 2018, 03:35:29 AM by Sebastiaan Fisscher »

Devon Austen

  • Staff
  • Diamond Member
  • *****
  • Posts: 257
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: PxPlus 2018 closing when trying to use key number 17
« Reply #5 on: August 02, 2018, 09:23:12 AM »
Thanks for the info.

We can reproduce the issue and are working on a fix that will be included in an online update.
Software Developer for PVX Plus Technologies LTD.