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.
Pages: 1 [2]
16
Programming / Data mirroring to SQL server
« on: May 12, 2021, 04:30:37 PM »
Greetings. We have a client that upgraded to PxPlus 2019 Update 2 a few months ago. Before their upgrade, we had been successfully using data mirroring to push their data to a SQL server. We have an AR file for them where the key is Customer + Invoice Number + Invoice Type. Invoice Type is a single character element, and it can be a blank space. (In fact, it frequently is; the ones with alphanum in it are less common.)
When the record is new, the mirroring/insert works fine, for any invoice record.
But when it is updating an existing record, the mirroring/update does not result in the table getting the updated data...if the record's Invoice Type is a blank. If the Type has an alphanum in it, it successfully updates the SQL table.
We have not gotten to the point yet of trying to step through it because of the complexity and the timeframe to dig down into it. And I'm not sure if watching our PxPlus command of write(channel) will tell us anything. Does this information trigger any sort of "aha!" explanation? TIA.
When the record is new, the mirroring/insert works fine, for any invoice record.
But when it is updating an existing record, the mirroring/update does not result in the table getting the updated data...if the record's Invoice Type is a blank. If the Type has an alphanum in it, it successfully updates the SQL table.
We have not gotten to the point yet of trying to step through it because of the complexity and the timeframe to dig down into it. And I'm not sure if watching our PxPlus command of write(channel) will tell us anything. Does this information trigger any sort of "aha!" explanation? TIA.
17
Language / %Z__PVXDDF$ global
« on: October 12, 2020, 11:49:50 AM »
Hello everyone. I hope you are all doing okay during this time.
Data Dictionary question. Can someone please give me a better understanding of the purpose of the %Z__PVXDDF$ global, and which programs -- apart from *dict/maint -- use it and how/why? TIA!
Paula McKeever
CAI Software LLC
Data Dictionary question. Can someone please give me a better understanding of the purpose of the %Z__PVXDDF$ global, and which programs -- apart from *dict/maint -- use it and how/why? TIA!
Paula McKeever
CAI Software LLC
18
Language / password protected data files
« on: October 12, 2020, 11:32:09 AM »
Greetings all; hope this finds everyone well during this time.
A question re: password-protected (PP) data files. We have a utility that runs through our data files, and it's supposed to run unattended, no interaction until it completes. As it loops through the files, the code attempts an open input on each (primarily to determine if it exists). With the pwd protection on a file(s), it now pops the prompt for the pwd if the file in question is PP. See attached.
So the question is: can we somehow predetermine that it is PP without the user interaction. The PxPlus panel in question, in the pgm _ext\system\get_pswd, launches automatically. I couldn't see a way to trap it before the panel displays. If a file is PP, we'll skip it.
TIA!
Paula McKeever
CAI Software LLC
A question re: password-protected (PP) data files. We have a utility that runs through our data files, and it's supposed to run unattended, no interaction until it completes. As it loops through the files, the code attempts an open input on each (primarily to determine if it exists). With the pwd protection on a file(s), it now pops the prompt for the pwd if the file in question is PP. See attached.
So the question is: can we somehow predetermine that it is PP without the user interaction. The PxPlus panel in question, in the pgm _ext\system\get_pswd, launches automatically. I couldn't see a way to trap it before the panel displays. If a file is PP, we'll skip it.
TIA!
Paula McKeever
CAI Software LLC
19
Nomads / Panel Compare
« on: March 11, 2020, 04:36:50 PM »
Hello. Using PxPlus 15.10. I've only just noticed this now, and it looks like it's been in Nomads for years, but...when the panel compare looks at text values, it does not consider case:
6030 if COMP$<>"C" then goto 6070 else if lcs(ITEM_OLD$)=lcs(ITEM_NEW$) then goto 6160
So e.g. "THIS IS A LABEL" vs. "This is a label" on a Fonted Text object does not show up on the compare results.
I don't suppose there's any consideration of making this case sensitive in some future release, the way that the Panel Search has a checkbox for case?
Thanks!
Paula McKeever
CAI Software
6030 if COMP$<>"C" then goto 6070 else if lcs(ITEM_OLD$)=lcs(ITEM_NEW$) then goto 6160
So e.g. "THIS IS A LABEL" vs. "This is a label" on a Fonted Text object does not show up on the compare results.
I don't suppose there's any consideration of making this case sensitive in some future release, the way that the Panel Search has a checkbox for case?
Thanks!
Paula McKeever
CAI Software
21
Programming / patch utility
« on: March 10, 2020, 03:03:32 PM »
Using PxPlus 15.10. There appears to be a limit to the number of characters in a line that the *patch utility will apply. We use *patch constantly, and it's been recently discovered that if a line is of a certain long length, the patch utility will put only a certain number of characters in. The utility will not report there being a problem (i.e. no message), and eventually we discover that our patched program has a syntax error because the line is chopped short. We're not sure if it's always been this way and we're only noticing it now, or if it's a recent development.
There's no documentation about the *patch utility, and the program is password protected.
Thanks in advance!
There's no documentation about the *patch utility, and the program is password protected.
Thanks in advance!
22
Programming / Re: providex.dde - null records?
« on: November 07, 2019, 07:58:23 AM »
Hmm, we rarely use external keyed files here, but even for one that I'm familiar with in our package, the DDE rec that has just the 6-digit DDF key has nothing in the iolist; each element in that DDE rec appears to be null.
23
Programming / providex.dde - null records?
« on: November 06, 2019, 11:26:35 AM »
We're currently using PxP 15.10 for our inhouse development. But we've been using the product since the days of ProvideX. That includes the Data Dictionary. Has anyone else noticed that in providex.dde, there is sometimes a record that has just the 6-digit serial # in the key -- i.e. no 6-digit sequence number making up the rest of the key -- at the front of a serial file's .dde records. And the iolist is null. Was there a time when, say, ProvideX used to instantiate one of these (header-like??) recs when writing .dde recs? Or are they just symptoms from a hiccough that might have occurred during a DD Maint process? We don't have them for all our serial #s; only some.
I also am wondering whether it's safe to delete them. For now, we're leaving them alone. Thanks!
Paula McKeever
CAI Software, LLC
I also am wondering whether it's safe to delete them. For now, we're leaving them alone. Thanks!
Paula McKeever
CAI Software, LLC
24
Language / Re: Embedded I/O program?
« on: November 06, 2019, 08:27:21 AM »
Mike King: File Open Failures did it. Thanks for the tip! Will make note of it.
25
Language / Embedded I/O program?
« on: October 31, 2019, 09:42:40 AM »
Hello! Using PxP 15.10. What's the way to find out the name of the embedded I/O pgm in a data file? We have a file that must have had an embedded I/O prgram updated into it, and then it was removed from the DD. But the physical file itself appears to still have the reference to it, and I'm guessing the program no longer exists b/c I'm getting an error 121 when I pull up the DD entry for the file. Thanks in advance.
Paula McKeever
CAI Software
Paula McKeever
CAI Software
26
Language / grid text color?
« on: June 07, 2019, 01:48:04 PM »
Is there any way to have a grid cell display part of its text in one color, and the rest of that cell's text in another? As a way to highlight the result of a search that can have multiple results (i.e. rows).
This is the date where...
The user runs the update to...
Dated today...
etc. My preference in this case is to use a grid, not a listbox. TIA!
Paula McKeever
CAI Software
This is the date where...
The user runs the update to...
Dated today...
etc. My preference in this case is to use a grid, not a listbox. TIA!
Paula McKeever
CAI Software
27
Nomads / (x) on buttons
« on: October 11, 2018, 01:37:29 PM »
Hello List. What controls the (x) bitmap to appear on buttons? See attached example. I can't figure it out, and I had trouble figuring out how to search for that in the documentation. Thanks!
Paula McKeever
Computer Associates
Smithfield, RI
Paula McKeever
Computer Associates
Smithfield, RI
Pages: 1 [2]