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

Issue finally resolved on creating Excel spreadsheet.

One other question - my customer uses a number of thin clients in the plant for production entry. All these clients have installed is the Windx client to run the PXPlus software.

It appears you cannot create an Excel spreadsheet from any of these machines do to the fact that Excel is not installed on them.

Is there a way to create and update a spreadsheet without having Excel installed?

Thanks!

Tom

Susan,

I was not using Windx with version 20.

I checked and have version 1600 installed.

I will open a support ticket per your suggestion.

Tom

Update - downloaded and installed demo version of version 20 and the program now works as expected.

I am wondering if I have the latest version of 16 installed. When I look on the website it shows 16.2 in the downloads section.

How can I determine exactly what version I have installed?

Thanks!

James,

hta(x_obj'sep$) = 8A

Windows Server 2019. Using Windx running on Windows 7, 10 and 11. Tried them all. Same result. Latest Excel version and also tried Excel 2016.

Also,

I tried the program on customer's system today and got the same results (v16)

Susan,

When I print x_obj'sep$ I get nothing back.

I added the visible statement and the sheet shows with the same wrong data immediately after the write.

Tom

James,

The retval after each step is 1

Tom

Susan,

Have you had any other thoughts as to how to solve this issue?

Anyone else on here have any ideas?

Thanks!

Tom

Susan,

The only thing that has been changed in the default settings is the font for the cells.

Everything is as it is from the initial install.

Using the latest version of Excel fully patched.

Thoughts?

Tom