Issue resolved. Ignore post.

I have just started receiving error 100 when I attempt to run certain programs. The error appears when the program attempts to 'Process' a panel.

Some of the programs work perfectly while others fail. This just started today. The failing programs have been around for a number of years with no issues.

Side note: I moved PvxPlus to a new Windows machine last Tuesday and everything seemed fine until today.  Also, all panels are contained in the same source file.

Any help would be greatly appreciated.

Tom Anderson

I have a situation where an existing PvxPlus installation is running on Server 2019 and Windx clients to connect to the server.

Customer is presently running in a local domain with all machines as members of the domain. This will be changed to a peer to peer network. The server machine will be replaced with a Windows 11 machine.

Is it possible to move PVXPlus to a Windows 11 machine and still use Windx to access the programs?

Thanks!

Tom

I am trying to call PvxPlus but all numbers are being reported as 'Out of Service'

Anyone know what is going on?

Tom

I tried the following but it didn't work:

03090 LET RANGE$="A1:I1"
03100 LET RETVAL=X_OBJ'SETRANGE(RANGE$)
03110 LET RETVAL=X_OBJ'EXCEL'COLUMNS'AUTOFIT()

What am I doing wrong?

Thanks!

Tom

  I am creating an Excel spreadsheet from a data file. Spreadsheet generation completes successfully.

Is it possible to set the Excel column widths from the default size before adding data to spreadsheet?

Thanks!

Tom

Got it to work!

Thanks for the assist.

Tom

James,

I tried the following but it doesn't work:

04550 LET GRID'SORT=5
04560 !
04570 GRID LOAD INPF_GRID.CTL,0,0,RR$

Suggestions?

Tom

I know you can set a sort for a grid column by clicking on a column header if enabled in the grid creation in Nomads.

Question: can you get the grid to sort on a particular column using code from within a program? In other words, cause the grid sort without user intervention.

Thanks!

Tom Anderson

Jane,

That's not a bad idea. The problem is that I would need to change the file open logic in 200 - 300 programs.

Would it be feasible to read 'providex.ddf' and 'providex.dde', modify the records containing 'C1' and create a new record for 'C2'?

Thanks!

Tom

Jim,

I may be looking at this incorrectly but it looks like this simply copies file 'A' to file 'B'.

What I need is to copy the file definition as contained in the files 'providex.dde and providex.ddf leaving the original data definition unchanged.

Tom

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 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 

Quote from: Mike Hatfield on May 08, 2024, 10:10:34 PM
I see that MS Excel - Data - Get Data - Other Sources- MS Query has disappeared from the latest version of Excel.
How do we now run PxPlus ODBC ?
Thanks

Mike,

This worked for us:

https://answers.microsoft.com/en-us/msoffice/forum/all/the-excel-microsoft-query-menu-option-has/33158d52-6d06-46a9-b848-9656d9957671

Tom Anderson

Devon,

Thanks for the suggestion. I'll look into it.

Off topic...there used to be a keystroke from a command prompt that would display all the current variable values on the screen.

For the life of me, I cannot remember what it was.

Can you help jog my memory.

Thanks!

Tom