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

Pages: [1] 2
1
Programming / Re: IT editor: Go To line focus
« on: March 04, 2024, 08:37:06 AM »
Aha. Eureka! Thanks Len!

2
Programming / IT editor: Go To line focus
« on: March 01, 2024, 10:14:25 AM »
(I wasn't sure how to word the subject line)  ;)

In the IT editor, if I go to a particular line -- let's say the first line in a routine/method -- is there a way to have the line load at the top of the display? The line in question loads partway down the screen, and I often have to scroll down to see the entirety of a routine that I might not need to if that first line appeared at the top. (By the way, we use line numbers in our installation.)

Just wondering if there's a way, for efficiency's sake. Thanks in advance!

Paula McKeever
CAI Software LLC

3
Registration and Setup / Re: PxPlus Help on Win 2022
« on: October 19, 2023, 12:02:27 PM »
That does indeed help, Stéphane. Thank you!

4
Registration and Setup / PxPlus Help on Win 2022
« on: October 18, 2023, 09:52:04 AM »
First time experiencing a Win 2022 server. Have PxPlus 2022 installed. The built-in Language Help (via the Help menu) does not display content on the right panel?
Might that be an issue with the 64-bit OS not playing nice with the HTML Help version? Or other?

Thanks in advance.

Paula McKeever
CAI Software

5
Programming / Data Dictionary Update *dict/dd_updt
« on: August 08, 2023, 04:09:47 PM »
Greetings. The Data Dictionary Update pgm *dict/dd_updt: it looks as though it returns error descriptions, not error numbers. If one's code happens to call it, will checking the err variable immediately upon returning from the call contain the error number associated with the returned message?

Thanks in advance.

Paula McKeever
CAI Software LLC

6
Language / Re: DD numeric definition for SQL validation
« on: February 17, 2023, 08:39:04 AM »
We've just discovered in the documentation for [ODB] open that the open can have parameters, including CHECK_NUMERICS. (Y/N) That seems to enforce the decimal check on the write. We're going to explore this further.

Still a little fuzzy about the "Force Data Validation on Write/Update" checkbox in DD Maint; not only does the test of the first number (e.g. the "8" in 8.2) seem to include the decimal point in the count, but that first number is for the digits to the left of and including the decimal point, not the total number of digits in the entire number (scale included, decimal point excluded) like for a write to SQL. If I understand correctly, a valid max for an 8.2 is

"Force Data Validation on Write/Update": 1234567.12
[ODB] write to SQL with CHECK_NUMERICS on: 123456.12


Paula McKeever
CAI Software

7
Language / Re: DD numeric definition for SQL validation
« on: February 15, 2023, 10:42:57 AM »
This is sort of a continuation of the original post.... We created a SQL table via PxPlus's database conversion util and have been doing some rudimentary testing to see if we can figure out what kind of rules we need to fashion for defining numeric size/precision in the DD. I.e. we've been setting numeric elements and writing them to the table that's opened via the [ODB] tag.

Let's take a numeric defined as 5.2 in our DD as an example. When we created the table, it showed as
CREATE TABLE SQL_Test
(TEST_KEY varchar(6) NOT NULL,
NUMBER_1 decimal(5,2), etc.

If I set the elem to 123.456789, the write doesn't error, which is what I was expecting. When I look at the data via SQL Svr Mgmt Studio, it shows  AS 123.46 ...rounded.

What's making it round? Is it it something on the PxPlus end or the SQL end?

TIA.

Paula McKeever
CAI Software LLC

8
Language / Re: DD numeric definition for SQL validation
« on: February 07, 2023, 10:41:40 AM »
Thanks Mike; that's a keeper link for sure. Not sure what it means in terms of my question though? We're seeking to potentially use an external SQL db for our Data Dictionary defined tables, and want to make sure that when we write to those tables via our PxPlus code, that the DD definitions for the numerics are of sufficient size and decimal setting. The PxP documentation was for me, on the surface, a little conflicting, but I'm betting there's an explanation out there that will clarify what we would need to do to adapt those DD definitions.

9
Language / DD numeric definition for SQL validation
« on: February 05, 2023, 04:05:35 PM »
Greetings all. Our rule of thumb with Data Dictionary numeric elements is to make them delimited, and we define them using this example in the PxPlus manual:

6.2: 6 represents total length of the field, including explicit signs and decimals, where applicable; 2 represents scaling factor or number of decimal places

So from that, we get that 999.99 is valid, but 9999.99 is too large, because the integer portion of the number is 6 minus 1 (the decimal point) minus 2 (the decimals), which is 3.

But when we consider the checkbox "Force Data Validation on Write/Update," the validation of the integer portion of the number -- using the above example -- appears to max out at 5 digits (decimal point separate), not 3. The documentation references the IOLIST directive for more detail about this data validation.

We're planning to expand our numerics so that, when exported to SQL, they are large enough to not cause an invalid number error of some kind. Does anyone know if the SQL validation follows the PxP validation rules?

I.e. if we have a 6.2 element, then it would accept a 99999.99 (or -99999.99), and by extension 999999.99 would cause an error?

Examples for illustration would be greatly appreciated. TIA,

Paula McKeever
CAI Software

10
Nomads / Re: Security property on folder tabs
« on: August 07, 2022, 01:30:08 PM »
My apologies. You're right; I should have said panel X has two tabs and it's X.1 that has the two controls plus the security. I will do a ticket.

11
Nomads / Re: Security property on folder tabs
« on: August 04, 2022, 01:54:09 PM »
Thanks Jane! So in my example... should I be thinking that it is the Y multi-line that is not behaving as it should? I.e. yes it's disabled when first drawn, but then I have code to enable all members of a particular group, of which Y and Z are part of said group. For USER (as well as MGR), Z enables, but Y stays disabled.

This was the behavior in my uber simplified test panel, as well as the existing FM panel. My test is a panel with two tabs, the first tab had multi-line Y and dropbox Z. I hit a button that does a call "*wingrp;Enable" for the only group that these two objects belong to. There are no other things, like dependencies, that might explain why Y stays disabled.   - Paula.

12
Nomads / Security property on folder tabs
« on: August 03, 2022, 12:14:47 PM »
(using PxPlus 2020, Windows server)
Greetings. This concerns the Security property on panels. There are some particular circumstances, as follows:

* Panel X with multi-line Y and dropbox Z, initially disabled
* Panel X has several tabs; let's call them X.1 and X.2
* Panel (tab) X.1 Security has, let's say...
   * Full access for Classification MGR
   * View-only access for Classification USER (we need that view access so that the tab always draws for everyone; everyone has at minimum the USER classification assigned to them)
* The situation in which we encountered this was a file maintenance type panel, but I confirmed this happens with a panel with tabs that was not generated as FM

So if a MGR launches the panel, the two objects are initially disabled as expected. If they then navigate to the first record in the file, that executes a process that enables the objects, because for a MGR, they should be enabled.

But for a USER, we expect the objects to remain disabled, and in fact for multi-line Y, the panel Security keeps it disabled. But dropbox Z enables, and that is not the behavior we expected. (This also happens when we try assigning the security to dropbox Z itself)

I look forward to your feedback.

Paula McKeever
CAI Software LLC

13
iNomads / Calendar Object: 1) display alignment 2) null value
« on: June 08, 2022, 10:43:16 AM »
Hello. Using PxPlus 2020. Is there a way to have a calendar object on a multi-line display =above= the m-l instead of below it?

My m-l control is low on the web page, and when the user clicks on the calendar's button, it pops partially below the visible area, and the user has to scroll down a little.

My other question is more to get a sampling of how are people handling the following scenario. If the date multi-line is null, the calendar pops as "Undefined 2000", and the user has to click on the year link, then the month link (the "Undefined") to get to a more approximate date. One solution is to default the date to today's date, but I'm not sure we want to do that in our particular business application. So I'm wondering if there are any creative solutions out there.

TIA!

Paula McKeever
CAI Software, LLC

14
Nomads / Panel Compares (LIBCREP) in v 18.20
« on: April 26, 2022, 04:17:14 PM »
I see that in PxP 2021 (v 18.20), when I do a panel compare, the LIBCREP panel now has a visual class assigned to the listbox. I'm guessing that's what changed the listbox font from a fixed font to a proportional font, so now the output no longer lines up visually. We're used to the fixed font because that way, we can more easily identify differences in the compares.

Was there a reason the font was changed for v 18, and if one were to remove the visual class from that listbox, would that mess things up?

Thanks!
Paula McKeever
CAI Software LLC

15
iNomads / Calendar Objects in iNomads
« on: March 07, 2022, 05:11:23 PM »
Hello. I've tried to get input from PvxPlus about this for the past six months via the support ticket queue, so now I'm trying the Forum.

I created a very simple panel/multiline with a Calendar object, barebones because I'm trying to just get it to work. See attached.

The specific Calendar object's definition is in the other screenshot attachment.


When I test it in regular Nomads by selecting a date from the popup calendar, it returns a date.
When I test it in iNomads by clicking on a date in the calendar, it returns nothing.
If I use my arrow keys to navigate to a new date and hit Enter, it kicks me out.

Has anyone had any luck with the calendar objects in iNomads?

Postscript added later: We've tried this in v. 2020 (17.10) and 2021 (18.20).

Thanks in advance.

Paula McKeever
CAI Software LLC

Pages: [1] 2