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

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

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

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


5
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

6
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

7
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

8
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

9
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

10
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

11
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.
Thanks.

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

Thanks





13
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

14
Thin Client/WindX / Re: Client-side FID(0)
« on: January 12, 2021, 05:47:05 PM »
in the past we had a requirement that a specific computer be assigned a specific fid so that a user could print to a specific printer but in the long run we found that to be cumbersome and restrictive.
We now have multiple methods of assigning fid.
A 'next' available from a fid pool
A range of fids dependant on a subnet
A specific fid based on computer id
A specific fid based on the user login - either from the local computer login name or domain login name or the application login name.
All this is controlled and assigned at the STARTUP or Application login.
Ultimately we don't really care what the fid actually is so long as it is unique.

15
Thin Client/WindX / Re: Client-side FID(0)
« on: January 12, 2021, 04:59:17 PM »
If the user starts multiple sessions on the PC do you expect each session to have a different FID or the same FID?

Pages: [1] 2 3 ... 5