We are pleased to announce that PxPlus 2024 (v21) is available for download.

PxPlus 2024 includes new features to keep your applications safe, secure and modern

• The Harvard Business Review reported a 20% increase in cyber security data breaches from 2022 to 2023. To protect your application and your customers' data, PxPlus 2024 is updated with the latest Security modules.

• In speaking with the developer community, we learned that many developers are using Visual Studio Code in other areas of their development teams. PxPlus 2024 includes a new extension to Visual Studio Code, an industry-leading code editor that is the preferred choice for many developers.

• In today’s competitive environment, the look and feel of an application is equally important as the functionality. PxPlus 2024 includes modern PxPlus toolkit interfaces showcasing Dark and Light modes, and new tools to update the look of your Nomads and non-Nomads based applications.

• Webster+, launched in 2021, provides developers with the optimal toolset to convert your application to browser based. PxPlus 2024 continues to enhance Webster+ with the ability to create and maintain screen library objects using a Web browser with Webster+ Inspector.

• We made it even easier for you to design your application screens for NOMADS and Webster+ with the new File Maintenance Generator Enhanced Layout.

For a complete overview of new features in this release, see the What’s New section.

---

Watch our short video introducing PxPlus 2024

---

Additional Resources

To download the software for PxPlus 2024, go to our Download Center.

To download the software for v8.00 PxPlus SQL ODBC Driver and PxPlus SQL Server , go to our Download Center.

For additional technical information, see our Documentation website.

The PVX Plus Team

Here is a routine I use on Windows to copy all files in a directory.
You can tweak it to change the filenames.

40400 COPY_DIR:! ^0200
40410 local fr_file$,to_file$,file_list$,command$
40420 ! needs fully pathed source$ and dest$
40430 source$=sub(source$,"/","\")
40440 call "*dirtree",source$,file_list$,sep,0
40450 while not(nul(file_list$))
40460 fr_file$=file_list$(1,pos(sep=file_list$)-1),file_list$=file_list$(pos(sep=file_list$)+1)
40470 to_file$=sub(fr_file$,source$,dest$)
40472 module$=fr_file$(pos("\"=fr_file$,-2)+1,2)
40474 if pos(module$=module_skip_list$,2) then continue
40480 ! Create any sub directories needed
40490 for i=1 to pos("\"=to_file$,1,0)
40500 directory to_file$(1,pos("\"=to_file$,1,i)),err=*next
40510 next i
40520 erase to_file$,err=*next
40530 command$=env("comspec")+" /c copy "+fr_file$+" "+to_file$
40540 invoke wait hide command$
40550 wend
40560 return

I have tables defined in the Data Dictionary in PxPlus 2023 version that I need to replicate in the same dictionary.

All of the files are labeled beginning with 'Cx' where x is the company identifier. For example, the customer master file for Company 1 is 'C1ARCUST'.

I need to copy all of the elements in 'C1ARCUST' to 'C2ARCUST'. Everything is identical except for the number at position 2. I see where this is doable one file at a time under Copy but am wondering if the is a bulk copy utility do all of the C1 files at one time.

Thanks!

Tom 

I receive an error 15 with
select count(distinct columnName) from table
msg(-1)=37000: [PxPlus][SQL ODBC Driver]Expected lexical element not found: <identifier>

How can I count distinct column values using ODBC 7.0.3?

It looks like the query definition for the multi-line control is not quite correct.  To use *win/email and *win/url the query for the multi-line control should be defined with Query Type of Query Program rather than Non-Query Logic.
 

There is documentation about these 'service' queries at:

https://manual.pvxplus.com/PXPLUS/NOMADS%20Graphical%20Application/Dictionary-Based%20Development/Query%20Subsystem/Service%20Queries%20for%20Web,%20Email%20and%20Map.htm