Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
ODBC / Re: ODBC with latest MS Excel
« on: May 09, 2024, 05:29:31 PM »
Hi Devon & Tom,
I see that you found the same solution as I did.
Thanks to all for the responses
I see that you found the same solution as I did.
Thanks to all for the responses
2
ODBC / Re: ODBC with latest MS Excel
« on: May 09, 2024, 04:54:37 AM »
Hi Ken, That is true but it doesn't allow the selections from the PxPlus ODBC 32/64 interface.
Typical of Microsoft to remove a feature that half the world uses without any explanation of how to work around.
However, I have done some research and I believe I have the solution.
You have to click on File - Options - Data
In Show Legacy data import wizards
tick From Data Connection Wizard (legacy)
tick From Microsoft Query (legacy)
OK
Back in the Spreadsheet
Click Data
Click Get Data
then in the Dropdown you will see Legacy Wiards - From Microsoft Queary (Legacy)
Et Voila!!
Typical of Microsoft to remove a feature that half the world uses without any explanation of how to work around.
However, I have done some research and I believe I have the solution.
You have to click on File - Options - Data
In Show Legacy data import wizards
tick From Data Connection Wizard (legacy)
tick From Microsoft Query (legacy)
OK
Back in the Spreadsheet
Click Data
Click Get Data
then in the Dropdown you will see Legacy Wiards - From Microsoft Queary (Legacy)
Et Voila!!
3
ODBC / ODBC with latest MS Excel
« 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
How do we now run PxPlus ODBC ?
Thanks
4
Programming / Re: Spawning a session
« on: April 18, 2024, 09:39:00 PM »
What if the application is not Nomads - Character only?
5
Programming / Spawning a session
« on: April 18, 2024, 01:34:40 AM »
Hi All, I'm running a plus/cs windx session.
I want to be able to open a new window/session from the current program.
In that new window I want to have it run a program that will display some lines of customer information text. When I find the text I want to switch back to the calling windx session and be able type in some of the text. When I'm done I want to close the new window/session either by clicking on the new session 'x' or issuing a close/drop or whatever in the calling program.
Would you believe in the nearly 26 years of programming with Pvx/PxPlus I've never had occasion to do this.
Is this accomplished by spawning a session or is there an easier way. I did do a test with *plus/cs/spawn. It gives me a new session window but none of the global variables from the calling application.
If this is the correct approach how would I place the following in the spawn argument cmdline - PROCESS "ARCM_INFO",%PATH_ROOT$+"dictionary/SM_CZ.EN",R2$
I don't seem to be able to do this with a dialogue window. IE Once inside the dialogue window you can't swith back and forth between the dialogue and calling program.
Thanks
I want to be able to open a new window/session from the current program.
In that new window I want to have it run a program that will display some lines of customer information text. When I find the text I want to switch back to the calling windx session and be able type in some of the text. When I'm done I want to close the new window/session either by clicking on the new session 'x' or issuing a close/drop or whatever in the calling program.
Would you believe in the nearly 26 years of programming with Pvx/PxPlus I've never had occasion to do this.
Is this accomplished by spawning a session or is there an easier way. I did do a test with *plus/cs/spawn. It gives me a new session window but none of the global variables from the calling application.
If this is the correct approach how would I place the following in the spawn argument cmdline - PROCESS "ARCM_INFO",%PATH_ROOT$+"dictionary/SM_CZ.EN",R2$
I don't seem to be able to do this with a dialogue window. IE Once inside the dialogue window you can't swith back and forth between the dialogue and calling program.
Thanks
6
Programming / Re: TCB(44) Always a Positive Number?
« on: July 10, 2023, 11:52:52 PM »
Our office is in Brisbane Australia - currently UTC+10
It's 13:52 here
TCB(44) is -36000
It's 13:52 here
TCB(44) is -36000
7
Programming / Re: Howto INCREASE External Key Size on DIRECT/KEYED files
« on: May 09, 2023, 11:35:47 PM »
Many moons ago in the days before self-expanding files we wrote a utility program to change key size, change record length and the number of records in the file. I think I was a lot younger then 
8
iNomads / Re: iPad device for remote support
« on: April 11, 2023, 05:26:49 PM »
Great Mike, looking forward to trying this on the new release.
As an aside....If you are looking to support the linux platform in general, then ANYDESK is a good option if you don't have access to tools like Connectwise Screenconnect. Anydesk will run on all common platforms. It is free for 'personal' use. It is also the only support tool we have found that will give you mouse/keyboard support from windows to an Android/IOS tablet. For example, if you are running an application, telnet session or soon to be iNomads from a tablet to a PxPlus host.
As an aside....If you are looking to support the linux platform in general, then ANYDESK is a good option if you don't have access to tools like Connectwise Screenconnect. Anydesk will run on all common platforms. It is free for 'personal' use. It is also the only support tool we have found that will give you mouse/keyboard support from windows to an Android/IOS tablet. For example, if you are running an application, telnet session or soon to be iNomads from a tablet to a PxPlus host.
9
Programming / Re: Strange if then else behavior
« on: March 09, 2023, 12:29:54 AM »
Ok, got it.
Is this what I should see? The listing includes the internal generated line numbers so that you can edit at the command prompt ?
:
-}list edit set_userid,
0071 Set_userid:
:
0072 IF NOT(%inomads'ForceLogon) AND %inomads'LogonReqd$<>"Y
: THEN LET %inomads'Userid$=NID;
: RETURN
0075 !
0076 DEF UID="*Void*" LOCAL
0077 CALL "*secure","F:LOGIN"
0078 DEF UID="*"
0079 !
0080 IF %inomads'Userid$=""
: THEN EXITTO SKIP_TX
0082 !
0083 IF %inomads'use_signon_uid
: THEN GOSUB Linux_signon WITH reqd_uid$=%inomads'Userid
0085 !
0086 RETURN
0087 !
0088 start_trace:
:
0089 LET x$=PTH("*plus/inomads/tracefiles",ERR=*RETURN)
0090 !
Press <ENTER> to continue or <F4> to exit:
Is this what I should see? The listing includes the internal generated line numbers so that you can edit at the command prompt ?
:
-}list edit set_userid,
0071 Set_userid:
:
0072 IF NOT(%inomads'ForceLogon) AND %inomads'LogonReqd$<>"Y
: THEN LET %inomads'Userid$=NID;
: RETURN
0075 !
0076 DEF UID="*Void*" LOCAL
0077 CALL "*secure","F:LOGIN"
0078 DEF UID="*"
0079 !
0080 IF %inomads'Userid$=""
: THEN EXITTO SKIP_TX
0082 !
0083 IF %inomads'use_signon_uid
: THEN GOSUB Linux_signon WITH reqd_uid$=%inomads'Userid
0085 !
0086 RETURN
0087 !
0088 start_trace:
:
0089 LET x$=PTH("*plus/inomads/tracefiles",ERR=*RETURN)
0090 !
Press <ENTER> to continue or <F4> to exit:
10
Programming / Re: Strange if then else behavior
« on: March 08, 2023, 06:15:22 PM »
Hi Mike, I had no idea you could do a LIST EDIT..... from the console prompt. very handy I think.
So, I thought I'd try it on the inomads program. The IT editor is set to 'editted list' and 'disallow lines'
I get this
-}LIST EDIT SET_USERID
0071 Set_userid:
:
Am I missing a setting somewhere?
Thanks
So, I thought I'd try it on the inomads program. The IT editor is set to 'editted list' and 'disallow lines'
I get this
-}LIST EDIT SET_USERID
0071 Set_userid:
:
Am I missing a setting somewhere?
Thanks
11
ODBC / Re: Dictionary definition for dates in YYMMDD format
« on: March 06, 2023, 04:51:17 PM »
Hi Devon,
I defined the class DATE-YYMMDD and it works. So simple and so obvious!
I have been trying all sorts of combinations around DATE-AAMMDD thinking that would be the right way to go.
Thinking about that I remember back to the Y2K 'bug' that this is specific to that point in time.
Thanks for the reply.
Follow-up question:
for the Class 'DATE' the element is auto-filled with 00/00/0000 and FMT=DD/MM/YYYY,DAYFMT=YYYYMMDD,INP=00/00/0000
for the Class 'DATE-YYMMDD' would an equivalent be 00/00/00 and FMT=DD/MM/YY,DAYFMT=YYMMDD,INP=00/00/00
Thanks again
I defined the class DATE-YYMMDD and it works. So simple and so obvious!
I have been trying all sorts of combinations around DATE-AAMMDD thinking that would be the right way to go.
Thinking about that I remember back to the Y2K 'bug' that this is specific to that point in time.
Thanks for the reply.
Follow-up question:
for the Class 'DATE' the element is auto-filled with 00/00/0000 and FMT=DD/MM/YYYY,DAYFMT=YYYYMMDD,INP=00/00/0000
for the Class 'DATE-YYMMDD' would an equivalent be 00/00/00 and FMT=DD/MM/YY,DAYFMT=YYMMDD,INP=00/00/00
Thanks again
12
ODBC / Dictionary definition for dates in YYMMDD format
« on: March 06, 2023, 01:23:03 AM »
We are working on a legacy system that has dates stored in the format YYMMDD.
We are trying to use ODBC with Excel to extract from the file with a criterium based on date EG select dates <= 30/06/22
What is the correct definition in the data Dictionary so that you can select by date in ODBC (EG 30/06/22).
Would we create a Date Class and apply that to the element and if so, how?
Thanks
Mike Hatfield
We are trying to use ODBC with Excel to extract from the file with a criterium based on date EG select dates <= 30/06/22
What is the correct definition in the data Dictionary so that you can select by date in ODBC (EG 30/06/22).
Would we create a Date Class and apply that to the element and if so, how?
Thanks
Mike Hatfield
13
Thin Client/WindX / Re: Automated Windx install
« on: November 13, 2022, 08:08:54 PM »
We have used Lindersoft - SetupBuilder Development Pro to create automated installs (and updates) of our application.
http://lindersoft.com/products_setupbuilder_dev.htm
If you are installing Windx it is a relatively trivial task to create the install script.
If you are installing PxPlus then you'll need to do a PxPlus silent install including the initial activation codes and then do the activation and registration later.
It's probably possible to create the script to complete the registration automatically but we haven't gone that far.
Hope this helps you
http://lindersoft.com/products_setupbuilder_dev.htm
If you are installing Windx it is a relatively trivial task to create the install script.
If you are installing PxPlus then you'll need to do a PxPlus silent install including the initial activation codes and then do the activation and registration later.
It's probably possible to create the script to complete the registration automatically but we haven't gone that far.
Hope this helps you
14
ODBC / Re: Updating a file from EXCEL PxPlus SQL Server
« on: October 19, 2022, 01:07:05 AM »
Hi Mike,
Appreciate your comments.
The thing is I had managed to get Excel to write back to the file at a client site.
This would have been at least 5 or 6 years ago. Naturally I have forgotten how I got it working
I remember it worked because I had to change the definition in the dictionary of a two-part key to the file.
It was stockcode 25 chars plus warehouse 2 chars.
Oh well. I'll try and find a MS Excel forum that might help.
Thanks
Appreciate your comments.
The thing is I had managed to get Excel to write back to the file at a client site.
This would have been at least 5 or 6 years ago. Naturally I have forgotten how I got it working
I remember it worked because I had to change the definition in the dictionary of a two-part key to the file.
It was stockcode 25 chars plus warehouse 2 chars.
Oh well. I'll try and find a MS Excel forum that might help.
Thanks
15
ODBC / Updating a file from EXCEL PxPlus SQL Server
« on: October 18, 2022, 06:23:06 PM »
I've created a test in our PxPlus SQL Server permissions setup for RW for any user and any company.
I've chosen a file and fields from the ODBC selection and now it is displayed in Excel.
What is required to have Excel write back to the file when you change a cell in the workbook.
Thanks
I've chosen a file and fields from the ODBC selection and now it is displayed in Excel.
What is required to have Excel write back to the file when you change a cell in the workbook.
Thanks