Recent Posts
11
Programming / Copy Data Definitions
« Last post by Tom Anderson on May 23, 2024, 02:56:51 PM »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
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
12
Programming / Copy Data Definitions
« Last post by Tom Anderson on May 23, 2024, 02:48:58 PM »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
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
13
Webster Plus / Folder/Directory browsing from Webster+ page
« Last post by pwhirley on May 23, 2024, 09:28:38 AM »In one of my file maintenance programs I need to select a folder from the SERVER to store in the record. At this moment it is up to the user to just fill the path in, but I'd love to allow the user to browse local and network folders from the server's perspective. I could not find a utility to allow this, but I'll be there is a way.
For the full story, the file maintenance identifies a printer and a folder. At the user's demand the program spawns a background process which continuously monitors the folder for CSV files containing information to be printed to labels on the printer.
Any ideas for allowing the user to select a folder?
Thanks - Phil
For the full story, the file maintenance identifies a printer and a folder. At the user's demand the program spawns a background process which continuously monitors the folder for CSV files containing information to be printed to labels on the printer.
Any ideas for allowing the user to select a folder?
Thanks - Phil
14
ODBC / count distinct not working
« Last post by Thomas Bock on May 22, 2024, 06:57:37 AM »I receive an error 15 with
How can I count distinct column values using ODBC 7.0.3?
Code: [Select]
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?
15
Off Topic / Re: Possible error in query logic?
« Last post by jhendrickx00 on May 21, 2024, 05:07:10 PM »You're right, my mistake. Thanks you!
Jean H//
Jean H//
16
Off Topic / Re: Possible error in query logic?
« Last post by Susan Cryderman on May 21, 2024, 10:54:18 AM »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
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
17
Off Topic / Possible error in query logic?
« Last post by jhendrickx00 on May 19, 2024, 05:34:28 PM »Hi, when using the *win/url and *win/email programs I got an ERR=28, below are some screen caps; of course, VERY probably I'm making a mistake, below are the captures:
18
Nomads / Modifying Calendar query
« Last post by jhendrickx00 on May 19, 2024, 03:52:44 PM » Hi, perhaps the sunday afternoon is hitting me... but I can't figure out how modify NOMADS created calendar (this associated to a multi_line query), I think I can use the DEF DTE to translate the days names, but didn't work. Any generous soul 
could be pointing in the right heading? Also want to see if I can move the calendar panel (to be at the side of control, no below)...
Thanks!
Jean H//
could be pointing in the right heading? Also want to see if I can move the calendar panel (to be at the side of control, no below)...Thanks!
Jean H//
19
Web Services / Re: Posting a File to a Web Service - > i got it to work
« Last post by Jeffrey Ferreira on May 18, 2024, 01:02:57 PM »Hi,
i got it to work
with Stephane's helper class.
thank you so much.
at least the response said message queued and i'm pretty sure that means it worked.
i have to read thru Stephane's class now and figure out what on earth he did.
jeff
i got it to work
with Stephane's helper class.thank you so much.
at least the response said message queued and i'm pretty sure that means it worked.
i have to read thru Stephane's class now and figure out what on earth he did.
jeff
20
Web Services / Re: Posting a File to a Web Service
« Last post by Jeffrey Ferreira on May 18, 2024, 12:33:29 PM »Here is my curl command that worked
curl -k -H "Content-Type: multipart/form-data" -H "Authorization: Basic Base64Credentials" -F file[filename]=@s:\jeff\Cleary_Quote.xml -X POST https://staging.saberis.com:9000/api/v1/documents/modules/21/upload
i'm going to try adding in what Stephane said and see if that helps.
curl -k -H "Content-Type: multipart/form-data" -H "Authorization: Basic Base64Credentials" -F file[filename]=@s:\jeff\Cleary_Quote.xml -X POST https://staging.saberis.com:9000/api/v1/documents/modules/21/upload
i'm going to try adding in what Stephane said and see if that helps.