PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: [1] 2 3 ... 10
Programming / Why use PVX?
« Last post by Cedric on June 14, 2024, 11:11:02 AM »
Hi guys,

I am currently debating with my team on the advantage of using PVX and why we should keep it.  I do have some arguments against them who try to push me out of PVX to use a more "standard" framework, but still, I am wondering what were your thoughts on it?

We've been using PVX for almost 25 years, but with all the new frameworks available that has a lot to offer, the question is relevant.  So, how to convince them that PVX is still relevant for us?  Our main product is an ERP system built 100% in pvxplus with WindX.  Our complimentary tools (web sites and mobile app) are built in Flutter and php mainly.  Note to say, we use our "in house" GUI engine... So no Nomads... 

I like the fact that PVX stays "retro" compatible, which makes it easy to maintain.  I also like the use of WindX, for control and security mainly.  The database is grest too.  All around, the performance is great for what we do, but there is some drawbacks that makes us rethink our strategy.
Programming / Re: *obj/GoogleSheets won't open spreadsheet
« Last post by pwhirley on June 14, 2024, 10:14:29 AM »
I was finally able to create a new spreadsheet then open a test one. 

I tried again to open the original sheet I need to work with, but it still fails with no indication of the reason.

This spreadsheet was shared with me and is, therefore, not actually in my drive.  I did not think this would make a difference to the API, but I'm unable to open the shared spreadsheet.

Any suggestions?

Thanks - Phil
Programming / *obj/GoogleSheets won't open spreadsheet
« Last post by pwhirley on June 14, 2024, 09:22:46 AM »
I have successfully authenticated with Google Workspace (*obj/GoogleSheets) and I have created the sheets object.  I have successfully logged in with sheets'Login().
The scopes for my app are ../auth/drive and ../auth/spreadsheets, which should give me full read/write access to both my drive and my sheets.

When I try either sheets'OpenSpreadsheetByID(SheetID$) or sheets'OpenSpreadsheetByPath(SheetPath$) the return is zero, indicating that it was not successful.  I have tried all sorts of changes but I have no idea why it is not opening the spreadsheet

Is there any error information available that will tell me why it is failing to open my spreadsheet?  All I need to do is grab the data from a range of cells, but sheets'READ$("J1:K31") failed with an error 42, which I presume is because there is no spreadsheet open to read from.

Any help would be appreciated.  It would be great if I could trace through the logic in the GoogleSheets.pvc, but apparently I am not authorized.

Thanks - Phil
Programming / Need help regarding cenPOS integration
« Last post by cwellis67 on June 12, 2024, 01:39:37 PM »
Hello all,
I am in the midst of replacing the old shell.explorer2 use of the Internet Explorer component while interfacing with CenPOS credit card processing. Has anyone else successfully done an integration with PxPlus and CenPOS (without using shell.explorer2)? If so, can you explain what you used? Was it a combination of using the newer *browser and *plus/web/request, or JavaScript, or a combination of both... or none of the above? Also at issue is creating a fix for prior versions of PxPlus before the *browser component was used.

Nomads / Re: Sort On Header Click / Row Height
« Last post by Jeffrey Ferreira on June 07, 2024, 02:34:25 PM »
I will give that a try Jane. Thank you.
Nomads / Re: Sort On Header Click / Row Height
« Last post by Jane Raymond on June 07, 2024, 02:30:57 PM »
Got it.
Take your querylist definition and change the Filter. Remove the Prefix settings and instead create a Test in the Selection Logic, something like:


This test will print the entire list if YOURVAR is blank, and if it's not it will look for the value in the data for the row which is found in REC(_MWR_IOL$).

REC(_MWR_IOL$) is somewhat esoteric, but looks like a value that would be useful for tests like this, so I'll create a new query variable containing its value for the next release.
Nomads / Re: Sort On Header Click / Row Height
« Last post by Jeffrey Ferreira on June 07, 2024, 11:02:57 AM »
Hi Jane,

So the problem that usually brings about these queries is the Customer, Vendor Name would be something like this:
Mast Road and Grain
and they want to search for Grain

This is my conundrum. The pxplus standard queries work fine when using the keys and typing in first few letters of key.

this is more like a key word search thru the entire row of data.

maybe there is no solution for this - i have coded around it before by checking to see if they clicked on Row -1 and executing Sort Logic myself but i was trying to avoid.

Nomads / Re: Sort On Header Click / Row Height
« Last post by Jane Raymond on June 07, 2024, 10:53:33 AM »
If you just want to display the records whose keys start with the value of the multiline, I have an alternate way to do this that doesn't require any coding. It involves using the smart control feature.
  • First, create a querylist with the fields you want in the report view or grid control you want to load. Add a filter where you add a Prefix based on your key (Primary Key or 'Sort By' Key), where the Prefix is an Expression that is the name of the multiline that has the value to be matched. (Side note - due to my key def I had to UCS() this value for it to work.)
  • Second, make your control 'Smart'. In the Attributes properties, click the Smart Load button, check Use Smart Load Logic and select the querylist you just created as the Panel. Under Trigger Variables and Controls, add the multiline control to Selected Triggers. Click OK and you're done.
  • Disable your current program logic on the multiline that hides your rows, as this will not be needed.
  • Test the panel. When you enter a value in your multiline, the list should reload with just the records that match and the columns will be sortable.
Nomads / Sort On Header Click / Row Height
« Last post by Jeffrey Ferreira on June 06, 2024, 07:44:00 PM »

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

Language / Re: Easiest way to create an XML file
« Last post by Stéphane Devouard on June 04, 2024, 04:44:40 AM »

Working daily at my job with *obj/xml to handle interfaces with an e-Commerce app API, I haven't been confronted with any memory issue in the last 2 years

*obj/xml represents an XML node, so internally, every single node or subnode of your XML document is an *obj/xml instance
IIRC the powerpoints from 20+ years ago, in PVX OOP, all instances of the same class share the logic (the methods are loaded in memory only once), only the instance data (properties) is distinct.
The actual XML string is created only when you use the 'get_xml$() method

In any case, Mike's logic is the best way to go if you're worried about memory usage

My 0.02€
Pages: [1] 2 3 ... 10