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

Pages: 1 [2] 3
16
Language / TSK to return NID
« on: March 19, 2019, 02:54:09 PM »
 TSK(*PROCESS LIST) gives me a list of pvx processes with a UID identifier.
Is there another TSK function that will give me a process list with a NID identifier?
Or some other way to get a list of all pvx processes with a NID identifier?

17
Nomads / Re: winqry ERROR=42
« on: December 28, 2018, 09:39:32 AM »
I agree... i could not find line 1875 in winqry either...
But our error routine captures the error details and is send to us via email.
Here is the captured error details:

Error#: 42 Error #42: Subscript out of range/Invalid subscript
MSG(-1) Message:
At line Number: 01875
Program Name: winqry (File Type: Keyed)
Version No: 6.18.01  Build#: 24581311  Date: Jan 12, 2018
Serial No: 1310-001-0148964

very strange...
I have sent them upgrades that will refresh all the PVX programs and our applications programs.

18
Nomads / winqry ERROR=42
« on: December 28, 2018, 08:00:17 AM »
Getting an ERR=42 in winqry line 01875
Version: 13.1
any ideas

19
Nomads / Re: Centering in a query
« on: December 06, 2018, 12:47:12 PM »
Will some sort of centering command/logic work?

20
Nomads / Re: Centering in a query
« on: December 06, 2018, 10:17:10 AM »
There is no alignment option on my screen.
i have attached a screen shot.

21
Nomads / Centering in a query
« on: December 05, 2018, 01:49:39 PM »
I thought this was easy but cannot see how to center data within a column in a query.
How is this done?

22
Programming / Re: Field Force development
« on: December 05, 2018, 12:47:56 PM »
I have no problem with the field checking function...
I was wondering what the best method would be to construct a maintenance routine that will allow the users to specify which fields are required.
I am thinking about a drop list populated from the file DD that would have check boxes for each field.
Is this the easiest method?


23
Programming / Field Force development
« on: December 05, 2018, 08:37:28 AM »
A client wants to be able to indicate what fields in their account master file of our application should be forced/required before an update is allowed.
They just need a maintenance routine to allow them to indicate which fields are required and a file to store the results.
Our existing update could check this new file to see if all required fields are filled in.

Just wondering what would be the fastest way to develop this in nomads?


24
Programming / Re: Backups and corrupted files
« on: November 22, 2018, 10:40:47 AM »
Paul, have you considered using the CREATE FILE directive to make your backups?
https://manual.pvxplus.com/page/directives/create_file.htm

This directive (added in PxPlus 2016) was specifically designed to help with this problem.  It does a high-speed data backup of active data files while placing a temporary lock on the file that prevents any updates. 

Assuming your files are a reasonable size you should be able create duplicate files fairly quickly.  For example on my Suse Linux server here I was able to create a backup of a 750MB file in under 2 seconds using the CREATE FILE directive.  The system prevented any updates to the file during this process but still allowed other processes to have the file open and simply stalled any updates until the copy was complete. A few second delay during off-hours is likely not going to be noticed.

In theory you should be able to create a program that makes copies of all your files as your backup and optionally ZIP that that directory up or transfer to another machine.  This should help assure you clean backups.
Trying to get the syntax of the command working with a channel number.
Can someone post a sample of the "CREATE FILE" command using a channle number.
Thanks

25
Off Topic / ITACIT interface
« on: October 11, 2018, 10:33:28 AM »
Has anyone done any integration with the ITACIT information system.
They use a REST interface to upload data.


26
Language / Re: Update a LIST_BOX
« on: July 25, 2018, 01:30:03 PM »
Actually its easier than that -- just set 'Item to the index for the item you want to change then set 'ItemText$ to the new value.

If you want to change the current item the set 'Item to 'CurrentItem and then change 'ItemText$. Here is a demo program.
Code: [Select]
0010 PRINT 'CS'; LIST
0020 LET Lb=100
0030 LIST_BOX Lb,@(40,1,12,6),FNT="*"
0040 LIST_BOX LOAD Lb,"Dog/Cat/Pig/Cow/Ant/Gnu/"
0050 WHILE 1
0060 SET_FOCUS Lb
0070 INPUT *
0080 IF CTL=4 THEN BREAK
0090 LET item=lb'currentItem
0100 IF item=0 OR CTL<1 OR CTL>3 THEN CONTINUE
0110 IF CTL=1 THEN LET Lb'item=item; LET Lb'ItemText$=UCS(Lb'ItemText$)
0120 IF CTL=2 THEN LET Lb'item=item; LET Lb'ItemText$=LCS(Lb'ItemText$)
0130 IF CTL=3 THEN LET Lb'item=item; LET Lb'ItemText$=CVS(Lb'ItemText$,256)
0140 WEND
0150 ! list_box remove Lb
0160 END
Run it and select an item from the list.  Pressing F1 will convert to upper, F2 lower, F3 mixed, F4 Quit
This works even better...

27
Language / Re: Update a LIST_BOX
« on: July 25, 2018, 01:29:10 PM »
Ed,
You have to remove the currently selected item, add your new item, then select it.  See lines 52-58 below

0010 print 'CS'; list
0020 list_box 100,@(2,14,12,6),fnt="*"
0030 list_box load 100,"Dog/Cat/Pig/"; wait 1
0040 list_box write 100,"Cat"; wait 1
0050 ! list_box load 100,1,*
0052 list_box read 100,_index ! Get index of current selection
0054 list_box load 100,_index,* ! Remove current selection
0056 list_box load 100,_index,"T-Rex" ! Add this one in its place
0058 list_box write 100,"T-Rex" ! Select the new option
0060 end

This is what i needed.

28
Language / Update a LIST_BOX
« on: July 25, 2018, 10:47:30 AM »
what is the command to update the currently selected item in a LIST_BOX with a new value?

29
Nomads / Re: New Query not pre-loading
« on: July 12, 2018, 09:26:38 AM »
I may have had a corrupt query... i re-defined it and it loads as expected now and very fast.

30
Nomads / Re: New Query not pre-loading
« on: July 11, 2018, 01:22:26 PM »
The new query does not actually pre-load data. This is an option setting for the classic query to allow column sorting. The new query will either load-on-demand or background load. The issue which you may be encountering is that you can only sort on a column when all the data has been loaded into the query listbox. With the classic query, there was no display until all the records were read, so when you clicked on the column header, the sort occurred. With the new query, records are displayed before they have all been read, so there could be a wait while records are being loaded before the sort could happen.

I was missing the "Loeading.." message that is on the classic query.

Would it be practical to put a loading message on the new query... So the user is aware that the records are still being loaded?


Pages: 1 [2] 3