Hi All,
I wasnt sure what section to put this under. Does anyone have any experiences they could share re: integrating their PxPlus Application with Square POS.

jeff

is there a way programatically to move a grid column once the grid is drawn..
i.e. something like shift column over 2 columns
jeff

We have descriptions that print in 30 character blocks.
is there a way on a multi-line (that has a height > 1 / i.e. multiple lines)
that i can control it so that if they type 30 characters on a line that it rolls to the next line.
i'm open to any solution.

Hello,

We have a client that is migrating from pxplus 16.20 to 19.10.
We have a Pxplus write record of a native sql command that reads from an Infor SQL Database.
In 16.20 it works but in 19.10 i get this error

HY000: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt

the command is just a "SELECT *" statement.

does anyone have any thoughts/insights.

jeff

I have a client using odbc client/server 5.20 - they migrated their app to a 64 bit version. On 2 files they are getting the following error:

Exception from HRESULT: 0xC0014020
Error at Purchasing Ledger Summary [ODBC Source [123]]: SQLSTATE: S0000, Message: [PxPlus][ODBC Driver][PXPIO]File does not exist;

they can query every other file fine. The file seems to be in the .ddf - has anyone ever seen anything like this?
thanks
jeff

I have a catalog.
If I just use The Data Dictionary - it works fine
If I just use the INI File - it works fine
If i use the Data Dictionary and INI File - it throws error on ini file files-> No Data Dictionary

can this be done?

Hi All,

I'm working on a program to display Delivery Pictures for a customer. I'm displaying the pics using Shell.Explorer. It is working nice except the pictures are really large. I found if I do a ctrl + scroll zoom in and zoom out. Is there a way i can do this with negative ctl's?

or maybe there is a way to fit the picture to the screen. We used shell explorer because it gives a preview of multiple docs (xml, pdf, any image, text)

thanks

jeff

I'm struggling with something that works but I don't understand why?

[*tables*]
Unit_Completion=p:\custom_data\CFUNIT
[Unit_Completion]
ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6
UTC_MTIME=STRING,LEN=10,FIELD=2,OFFSET=0

Can someone tell me what ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6 what this is doing?
it does what i want but intuitively i feel like it should not be working.

this is probably totally pie in the sky...
is there any way in pxplus that i can drop a file on to something say like from Email Outlook on to a control and get access to that file in some way.
what i'm trying to do is associate a pdf with an invoice or quote.

Hello,

I sometimes make custom queries where as the user types into a multi-line I hide rows via the RowHeight property to zero for those rows that don't meet search criteria. Customers seem to really like it, the only problem is when they ask me to enable 'SortOnHdrClick.

If i filter rows via the row height then if they click a column it just messes it up.
is there a way i can do both / hide rows and still have sort on header click enabled

jeff

Hi List,
in the past i could never get *plus/web/request work with uploading a file.
i can get it to work in postman, curl and powershell....but i cannot get syntax right in pxplus
i'm referring to line 100 .
does anyone know what i'm doing wrong or has used *plus/web/request to post/upload file
i dont want to use a 3rd party utility if i can help it

0040 let RAW_CREDENTIALS$="username:password"
0050 call "*web/base64;ENCODE_STR",RAW_CREDENTIALS$,BASE64_CREDENTIALS$
0060 let EXTRA_HEADERS$="Authorization: Basic "+BASE64_CREDENTIALS$
0070 let MIME_TYPE$="multipart/form-data"
0080 let URI$="https://staging.saberis.com:9000/api/v1/documents/modules/21/upload"
0100 let BODY$="filename=Cleary_Quote.xml"
0110 call "*plus/web/request",URI$,BODY$,RESPONSE$,RESPONSE_HEADER$,MIME_TYPE$,"",EXTRA_HEADERS$


thanks

jeff

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:

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

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

Hi All, when copying a panel is there is a difference between clicking the "OK" button and clicking the "Apply" button?

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

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)

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

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

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