PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: [1] 2 3 ... 10
1
Programming / Re: Future of PVX plus?
« Last post by PxPlus on Today at 08:08:07 PM »
Hi Martin,

Thanks for the post.  PVX Plus Technologies will continue to develop and enhance the language and toolset. Our dedicated and engaged team is currently working on the next release scheduled for May 2024.  We will continue to offer new releases designed to enhance our customers applications and solve your pain points.

Keep in touch.
2
General Announcements / Update from PVX Plus Technologies
« Last post by PxPlus on Today at 05:12:00 PM »
All of us at PVX Plus Technologies would like to express our best wishes to the King's as they embark on their new stage of life. We will miss the constant presence of Mike’s innovative genius and Rosalba’s impeccable organization that have guided us throughout the years. We wish you much success in your new endeavours, and we are also looking forward to connecting with you in the role of consultants.

In March of this year, PVX Plus was sold to Jonas Software. Jonas Software was the right choice as they offer the most solid foundation to support the continued growth of PVX Plus Technologies over the long term. PVX Plus Technologies will continue to develop and enhance the language and toolset. Our dedicated and engaged team is currently working on the next release scheduled for May 2024.  We will continue to offer new releases designed to enhance our customers applications and solve your pain points.

In addition to our team of experienced developers staying with the company, we are pleased to announce that our team is growing. In the past couple of months, we have added two new team members and are in the process of hiring a third. 

We look forward to working in collaboration with our customers to understand and solve your challenges.

For those who aren't on our mailing list, please sign up here.
 

Thanks,
The PVX Team
3
Programming / Re: create a pivot table
« Last post by Devon Austen on Today at 11:50:07 AM »
Glad you resolved your issue.

Thanks for sharing the answer.
4
Programming / Re: create a pivot table
« Last post by Thomas Bock on Today at 04:24:13 AM »
SOLVED!

The trick is to use piTable'dataFields()
Code: [Select]
lastItem = piTable'dataPivotField'pivotItems()'count
lastPiField = piTable'dataFields(lastItem)
lastPiField'function = -4106
lastPiField'numberFormat$ = mask$
lastPiField'caption$ = title$
5
Programming / Future of PVX plus?
« Last post by martinp on November 30, 2023, 08:59:15 PM »
Hi I was just wondering what is in store for the future of PVX PLUX?  Will there still be yearly developments?
6
That should be fine.  Here's the Pvx Help File Link if you need it: https://manual.pvxplus.com/PXPLUS/file_handling/~pdf~.htm

There's some examples in the help files, too.

Best,
Jonathan
7
Registration and Setup / strange behvior regarding mapped drives
« Last post by cwellis67 on November 30, 2023, 12:10:40 PM »
I have PvxPlus 19.10 installed in a folder, "C:\933\pvx". When I run the executable from that pvx folder and try to open a file on mapped drive, I get a message saying the file does not exist. However, if I rename the home folder to "C:\933rename" (or anything else), and then launch PxPlus from the pvx directory, I can open the file on the mapped drive. I've never had this issue before, and everything else seems to work fine EXCEPT for opening a file on a mapped drive.
8
Programming / create a pivot table
« Last post by Thomas Bock on November 30, 2023, 02:57:10 AM »
Has someone created a Pivot table with an average column so far?
I recorded a macro in MS-Excel

Code: [Select]
    With ActiveSheet.PivotTables("Pivot1").PivotFields("Percent")
        .Caption = "Average %"
        .Function = xlAverage
    End With

This is my translation to PxPlus
Code: [Select]
pivotName$ = "Pivot1"
fieldName$ = "Percent"
title$ = "Average %"
piTable = sheet'pivotTables(pivotName$)
piField = piTable'pivotFields(fieldName$)
piTable'addDataField(*piField)
lastItem = piTable'dataPivotField'pivotItems()'count
lastPiField = piTable'dataPivotField'pivotItems(lastItem)
lastPiField'caption$ = title$
piField'function = -4106 ! xlAverage

I always receive an error 88 on the last line.
The macro seems to be wrong, because the caption can only be set on lastPiField instead of piField.
Help is appreceated.
9
Video Library / PxPlus 2023 - Using Webster and database access video series
« Last post by PxPlus on November 29, 2023, 04:37:13 PM »
Introducing our seven part video series on PxPlus 2023.

These videos will showcase many of the new features of PxPlus 2023 highlighting both Webster+ and the PxPlus Database interfaces.


For full details on this release please see our Release Info page.
10
Programming / Re: temporary error 11
« Last post by James Zukowski on November 29, 2023, 08:55:48 AM »
This may have something to do with the file being built as an EFF file.
See EFF vs VLR File Formats for further details.
Pages: [1] 2 3 ... 10