PxPlus User Forum

Twitter Twitter Twitter

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.

Messages - Mike Hatfield

Pages: [1] 2 3 ... 5
Programming / Re: Spawning a session
« on: April 18, 2024, 09:39:00 PM »
What if the application is not Nomads - Character only?

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.


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

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

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.

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$=""
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:

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

0071 Set_userid:
Am I missing a setting somewhere?

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

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?

Mike Hatfield

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.


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

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.

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.

Thin Client/WindX / Re: Simple CS Client on V17
« on: May 01, 2021, 12:02:44 PM »
Hi all,

I worked it out.
V17 ini file was missing the IPV4 only line.

Thin Client/WindX / Simple CS Client on V17
« on: May 01, 2021, 11:39:14 AM »
We have been using Simple CS Host and Client since it was introduced.
However I simply cannot get it to work with V17
Windows Server 2016 and Windows server 2019.
On the Server 2016 we have V16 installed in ...HIT\pvx and the Simple Client service running..
We've installed V17 in ..HIT\pvx17 and cloned the application icons, stopped the V16 service, started the V17 host from the desktop and changed the start folders in the application start icons.
I see the client screen flash up on the desktop and it dies straight away.

On the Server 2019 we've installed V17 into ..HIT\pvx and setup the service and created the icons the same as our V16 server.
when I try to start the application I see the same client flash on the screen and the client dies.

I am thinking there is a difference in V17 from V16, but what....?

If I start the V17 host on the desktop from the Pxplus start menu I can start the simple client from the start menu.

Clearly I am missing something here, but what?


Programming / Re: converting providex to pxplus - *viewer*
« on: April 03, 2021, 08:49:44 PM »
*viewer is included in PxPlus
You can also define a generic text Local printer - yourname VIEWER - on port NUL. eg name the printer - MyApp Viewer
This is also available for PDF. EG Myapp PDF

Pages: [1] 2 3 ... 5