This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
ODBC / ODBC Service Crashing
« on: April 12, 2024, 08:09:26 AM »
Hello All,
I have a customer who uses ODBC a lot to access their pxplus files. We have service crashes quite often.
I'm assuming the first thing we should do is update their ODBC Version but before we do that, is their anything that could possibly be going on
thanks
jeff
Error Message:
Faulting application name: pxpiosvr.exe, version: 5.20.0.0, time stamp: 0x51815515
Faulting module name: ntdll.dll, version: 10.0.14393.6343, time stamp: 0x6502749b
Exception code: 0xc0000005
Fault offset: 0x000587a9
Faulting process id: 0x8d2c
Faulting application start time: 0x01da8ccff7520e30
Faulting application path: C:\PVX Plus Technologies\File Server\pxpiosvr.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: e605ac47-8a76-4ee5-abcb-93544bd6bc91
Faulting package full name:
Faulting package-relative application ID:
I have a customer who uses ODBC a lot to access their pxplus files. We have service crashes quite often.
I'm assuming the first thing we should do is update their ODBC Version but before we do that, is their anything that could possibly be going on
thanks
jeff
Error Message:
Faulting application name: pxpiosvr.exe, version: 5.20.0.0, time stamp: 0x51815515
Faulting module name: ntdll.dll, version: 10.0.14393.6343, time stamp: 0x6502749b
Exception code: 0xc0000005
Fault offset: 0x000587a9
Faulting process id: 0x8d2c
Faulting application start time: 0x01da8ccff7520e30
Faulting application path: C:\PVX Plus Technologies\File Server\pxpiosvr.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: e605ac47-8a76-4ee5-abcb-93544bd6bc91
Faulting package full name:
Faulting package-relative application ID:
2
ODBC / slowing down an ODBC query
« on: February 20, 2024, 11:31:43 AM »
Hi All,
we are having an issue whereby when a user does a power bi query against our pxplus data via odbc it really can slow down performance for everyone else. Does anyone know of a way i can slow down/throttle pxpiosrv. Or maybe some other solution.
Jeff
we are having an issue whereby when a user does a power bi query against our pxplus data via odbc it really can slow down performance for everyone else. Does anyone know of a way i can slow down/throttle pxpiosrv. Or maybe some other solution.
Jeff
3
Programming / Flash a Message
« on: January 25, 2024, 02:15:21 PM »
Hi All
is there a way to flash a message on the screen in a multiline and then clear it after a few seconds.
i was going to implement with the timeout but i thought i would ask if there was a more sophisticated way to do this.
i'm trying to avoid adding message boxes.
thanks
jeff
is there a way to flash a message on the screen in a multiline and then clear it after a few seconds.
i was going to implement with the timeout but i thought i would ask if there was a more sophisticated way to do this.
i'm trying to avoid adding message boxes.
thanks
jeff
4
Nomads / Copying a Panel
« on: January 18, 2024, 10:02:02 AM »
Hi All, when copying a panel is there is a difference between clicking the "OK" button and clicking the "Apply" button?
5
Hi List,
we have a grid that displays images for the different options a customer can pickup.
i'm trying to set the 'bitmap$ option and i'm getting an error 17
it is an older version of pxplus (15.##)
does anyone know what would cause this
i tried a jpg and a png file and i get same error
jeff
we have a grid that displays images for the different options a customer can pickup.
i'm trying to set the 'bitmap$ option and i'm getting an error 17
it is an older version of pxplus (15.##)
does anyone know what would cause this
i tried a jpg and a png file and i get same error
jeff
6
Hi All,
I had an odd situation happen.
I do this thing where I first create record to make sure it exists before I extract it.
I got a dom on line 21027 and i cannot figure out why?
does anyone have any insight on how this could/might happen
20002 let MFIM01=unt; open (MFIM01,iol=*,rec=CF$)"MFIM01"
21024 let CF.SALES_ORDER_NUMBER$=SALES_ORDER_NUMBER$
21025 let CF.LOCK_ALLOCATIONS$="Y"
21026 write (MFIM01,dom=*next) ! Do Not Step On Record If It Exists
21027 extract (MFIM01,key=SALES_ORDER_NUMBER$,kno=0)
I had an odd situation happen.
I do this thing where I first create record to make sure it exists before I extract it.
I got a dom on line 21027 and i cannot figure out why?
does anyone have any insight on how this could/might happen
20002 let MFIM01=unt; open (MFIM01,iol=*,rec=CF$)"MFIM01"
21024 let CF.SALES_ORDER_NUMBER$=SALES_ORDER_NUMBER$
21025 let CF.LOCK_ALLOCATIONS$="Y"
21026 write (MFIM01,dom=*next) ! Do Not Step On Record If It Exists
21027 extract (MFIM01,key=SALES_ORDER_NUMBER$,kno=0)
7
Language / ** DISEGARD ** -> Mixed Case in Keys
« on: August 03, 2023, 12:07:07 PM »
Hi List,
i was about to embark on a project for a client and i figured i better confirm the following before i begin.
we have an index -> The Customer's PO Number
sometimes it comes in Mixed Case .......
my question is -> are Keys always case sensitive...
i'm pretty sure the answer is yes but i dont want to start this workaround unless i'm 100% sure....i just want to make sure there is no cool feature in pxplus that i'm unaware of
thanks
jeff
i was about to embark on a project for a client and i figured i better confirm the following before i begin.
we have an index -> The Customer's PO Number
sometimes it comes in Mixed Case .......
my question is -> are Keys always case sensitive...
i'm pretty sure the answer is yes but i dont want to start this workaround unless i'm 100% sure....i just want to make sure there is no cool feature in pxplus that i'm unaware of
thanks
jeff
8
Nomads / Checking if 'Fired Off From' Nomads
« on: July 14, 2023, 09:17:23 AM »
Hi All,
So often times we will gosub or perform a routine that is also the code behind a multi-line. For Example CUSTOMER_ID_ENTERED.
When we want to know if this came from nomads or from code we check ID$="CUSTOMER_ID".
I know it may seem like I'm splitting hairs but i feel this is not 100% foolproof and i have case where I really need to know (was this routine fired off from Nomads via the multi-line)
is there a way i can be 100% sure?
thanks
jeff
So often times we will gosub or perform a routine that is also the code behind a multi-line. For Example CUSTOMER_ID_ENTERED.
When we want to know if this came from nomads or from code we check ID$="CUSTOMER_ID".
I know it may seem like I'm splitting hairs but i feel this is not 100% foolproof and i have case where I really need to know (was this routine fired off from Nomads via the multi-line)
is there a way i can be 100% sure?
thanks
jeff
9
Programming / Screen Position of a Control
« on: June 21, 2023, 08:44:27 AM »
Hello All,
i'm trying to figure out where a pxplus control is positioned relative to the monitor not relative to the pxplus panel.
i'm also not sure what is standard unit of measure for stating this (i think it is pixels)
can anyone help me out?
thanks
jeff
i'm trying to figure out where a pxplus control is positioned relative to the monitor not relative to the pxplus panel.
i'm also not sure what is standard unit of measure for stating this (i think it is pixels)
can anyone help me out?
thanks
jeff
10
Hi All,
if i make a long html tip inside of nomads it displays nice.
if i do it in code via the tip$ then i'm getting a vertical scroll bar (and the tip is not even that long).
i'm using version 16.20 .
does anyone know a way i can rid myself of this vertical scroll bar
thanks
jeff
if i make a long html tip inside of nomads it displays nice.
if i do it in code via the tip$ then i'm getting a vertical scroll bar (and the tip is not even that long).
i'm using version 16.20 .
does anyone know a way i can rid myself of this vertical scroll bar
thanks
jeff
11
Programming / Auto Clicking Buttons and entering data
« on: May 11, 2023, 03:13:11 PM »
Hi List,
i have handled this different ways in the past and i'm wondering if someone has some input on a better way to handle it.
I have a gui screen that has been around a while. The client is giving me a file which is the input for the screen. But unlike something like Excel.Application there is no api for the screen. Is there a better way to simulate the user clicking on buttons and filling out the fields than what i have done in the past which is to:
a.) fire off screen with some argument saying Auto Mode
b.) then go to a routine that will do something like this
1.) Item_Number = passed in item Number
2.) gosub item_number_changed
3.) Quantity = passed in quantity
4.) gosub quantity changed
thanks jeff
i have handled this different ways in the past and i'm wondering if someone has some input on a better way to handle it.
I have a gui screen that has been around a while. The client is giving me a file which is the input for the screen. But unlike something like Excel.Application there is no api for the screen. Is there a better way to simulate the user clicking on buttons and filling out the fields than what i have done in the past which is to:
a.) fire off screen with some argument saying Auto Mode
b.) then go to a routine that will do something like this
1.) Item_Number = passed in item Number
2.) gosub item_number_changed
3.) Quantity = passed in quantity
4.) gosub quantity changed
thanks jeff
12
Programming / Preview / Viewer Object
« on: April 06, 2023, 02:15:54 PM »
Hi List,
A long time ago Gord Davey helped me invoke a viewer object where i could interact with the viewer. I have lost the code and I cant remember how to do it. Can anyone help me with that?
thanks
jeff
A long time ago Gord Davey helped me invoke a viewer object where i could interact with the viewer. I have lost the code and I cant remember how to do it. Can anyone help me with that?
thanks
jeff
13
Language / *X Mnemonic / Print Channel Timing Question
« on: March 07, 2023, 10:16:30 AM »
Hi All,
i'm trying to use *X mnemonic to print to a text file and email to customer.
But i noticed that when I enter the call entry point the file is still open and locked for that matter.
I added another close inside of the call routine and that worked (i could access file).
But is this correct / good practice?
Jeff
i'm trying to use *X mnemonic to print to a text file and email to customer.
But i noticed that when I enter the call entry point the file is still open and locked for that matter.
I added another close inside of the call routine and that worked (i could access file).
But is this correct / good practice?
Jeff
14
ODBC / ODBC Date Issue
« on: March 03, 2023, 08:14:56 AM »
Hi All,
We are using ODBC Driver 7.00.
If we do the following in Excel
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "09/01/2022"
it returns every order up until 12/31/2022 and does not return anything from 2023
if we do
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "01/01/2023"
then it returns the 2023 orders
has anyone ever seen this or know what i could be doing wrong?
thanks
jeff
We are using ODBC Driver 7.00.
If we do the following in Excel
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "09/01/2022"
it returns every order up until 12/31/2022 and does not return anything from 2023
if we do
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "01/01/2023"
then it returns the 2023 orders
has anyone ever seen this or know what i could be doing wrong?
thanks
jeff
15
Programming / Outlook Appt or Meeting
« on: January 30, 2023, 01:15:51 PM »
Has anyone ever been able to send an email via *web\email to create an Outlook Meeting or Appointment?
Not sure if it is even possible.
jeff
Not sure if it is even possible.
jeff