Hello List,

I have a grid where some of the rows are hidden. But when they click on Header Sort. Those rows become visible. I have developed a work around to deal with this but it is kind of clunky. Question when a user clicks a header on a grid to sort does it send any kind of signal that i can trap for an re-evaluate which rows should be hidden?

i hide the rows because of filters and it takes so long to load data into grid.

thanks

jeff

I'm not sure what category to even put this under.
we have an an array that contains data like this:

key_pair$[1]="order_number$"+$01$+"123456"
we do
read data from key_pair$,sep=$01$ to variable$,value$

after that we do a via to assign value to variable...
here is the weird thing:
every now and then we will get one of the characters in order_number$ will be like -64 in terms of ascii value

so the _ is asc 95
we will get the asc 31 character instead

sometimes the R asc 82 will be asc 18

has anyone ever had anything at all like this happen?

thanks jeff

Hi All
we have a list box that has plenty of space to hold data in columns yet after certain column data we get ...
it causes confusion for Order Entry folks because they are not sure if they are picking the right item number.
Does anyone know what i can do to stop this?
i attached a file here.

jeff

Hello,

I've generated JSON from an associative Array before. However, this next project i'm working on kind of requires an outer array (i.e. square brackets)...i'm not sure how to do that but the sample file looks like this:

[
   {"Order":"123456",
    "Customer":"ABC Co",
   }
   {"Order":"123457",
    "Customer":"XYZ Co",
   }
]

do i need to just build the inner JSON portions and then append the Square Brackets to beginning and end of the String before posting to web service?

thanks

jeff

Hi All,

When looking at code that didn't use parentheses I want to understand what pxplus is doing behind the scenes.

in the following

X=1 OR 0 AND 0
PRINT X

X WILL EQUAL 0.

Can someone state why this is? (Michael Scott: "Explain it me like I'm 5")

Hello All,
is there any file or util that we could look at to see what processes are using Licenses.
the customer is trying to figure out which pxplus processes are using the licenses and which ones are not
thanks
jeff

Hi All,

a client asked there was a way when we are displaying our images in a grid for product options if there was a way they could right click on the option and copy it so that they could paste in an email to send to customers.

is this possible?

jeff

Hi All,

I think this might be a window thing but i thought i would ask.

We have a screen with several Standard List Boxes on it. They are product options.
Color, Width, Height, Radius etc.

When they click one option - the other one still shows selected but it is like 'faint grey' and it is hard to see it selected. In the past I made a multi-line on top of it that showed selection (re-iterated it). Is there any way i can make the selected option more pronounced even when it does not have focus.

thanks in advance.

jeff

Hello All,

I have a client that is querying our database and it works fine in 64 bit excel. When they try to query it using SQL Server Integration Services it is doing all kinds of funky conversions on our simple data. For Example: We have a Customer ID that is 6 in length (string) and it is trying to convert it to a LOB (Large Object) and the query just returns back a bunch of nulls. Has anyone had any experience with this?

jeff

Hi List,

we have the following situation.
program 1 calls program 2
program 2 calls program 3
program 3 calls program 4

program 4 errors out.
we have a generic error routine where we click a diagnose button.
at just one of our accounts when we click Diagnose pxplus exits/bubbles up to program 1 instead of remaining in program 4.

does anyone know what I might have set to cause this.

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