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.
121
Programming / Re: excel object create error 12
« on: November 29, 2018, 03:16:16 PM »
This turned out to be a Windows issue (all gasp in surprise). On the properties for the application launch icon, under compatibility, the Compatibility was turned on for WindowsXP (Service Pack 3). Turning this off eliminated the problem. This was only an issue with the latest version of Excel.
122
Programming / Re: Backups and corrupted files
« on: November 21, 2018, 04:22:54 PM »
Paul,
In my experience backing up a file that is actively being updated during the time it is actually being backed up will guarantee corruption. I'm not sure of the exact sequence that PxPlus uses to update files (header locks, data writes, etc), but the scenario is simply this. You have already backed up a part of a file which an update may change, and then will back up further toward the end of the file with "updated" data. This clearly introduces internal inconsistencies which appear as corruption.
In my experience backing up a file that is actively being updated during the time it is actually being backed up will guarantee corruption. I'm not sure of the exact sequence that PxPlus uses to update files (header locks, data writes, etc), but the scenario is simply this. You have already backed up a part of a file which an update may change, and then will back up further toward the end of the file with "updated" data. This clearly introduces internal inconsistencies which appear as corruption.
123
Programming / excel object create error 12
« on: November 16, 2018, 02:56:49 PM »
I have a customer who has several users running the same version of excel, and of course pvx/windx on different PC's. One user gets and error 12 on this command:
3215 def object xl,"[running]excel.application"
"[running]ecel.application" is actually in a variable, but the above shows the command. Does anyone know of an excel setting which would cause this?
Thanks!
Michael
3215 def object xl,"[running]excel.application"
"[running]ecel.application" is actually in a variable, but the above shows the command. Does anyone know of an excel setting which would cause this?
Thanks!
Michael
124
ODBC / Re: MySQL write via ODBC
« on: October 18, 2018, 02:20:46 PM »
Curiously, I just tried the update option and it a) created a second row b) added a row after I had deleted the existing record(s). This must be telling us something about the target table and how it is configured.
125
ODBC / MySQL write via ODBC
« on: October 17, 2018, 04:10:00 PM »
I have a standard interface to various MySQL databases that have the same table format. In one instance I am getting duplicate rows when I write the same record rather than overwriting. The MySQL database is not under my control. It is my understanding the PxPlus handled the determination of whether to do an update or an insert. I am opening the table with a unique key specified. The insert/duplication occurs whether I write with a key or not. Is there some open option that I did not notice that will help with this behavior?
126
Registration and Setup / Re: Windx Security
« on: September 19, 2018, 02:53:44 PM »
I am good with this all on a single workstation. Is there a way to control how this behaves on a terminal server? Is there a base config file that is copied to each user which we could tinker with so that the security defaults to no/off?
127
Registration and Setup / Re: Windx Security
« on: August 20, 2018, 04:49:31 PM »
Mike, just FYI that ALT-Space brought me to the same menu as did clicking the PxPlus globe, and the reset would not work. On the other hand, removing the referenced file ( I resisted the urge to edit the security from YES to NO, since you didn't suggest that) did the trick. Michael
128
Registration and Setup / Windx Security
« on: August 20, 2018, 04:05:01 PM »
I had a customer enable windx security on their own initiative. I have attempted to reset Windx Security, both by clicking on the PxPlus globe and then clicking reset, which does nothing, as well as trying the shift+ctrl+insert, which did nothing. I even did a remove/re-install to no avail. What am I missing?
129
Nomads / Data Read logic in nomads DD or View definition
« on: July 09, 2018, 12:44:29 PM »
I don't really use nomads, but use the Data dictionary and views definitions to create ODBC links to PVX data. Is there a way to create a column in a table or view that includes logic to set the value of the field based on other fields in the record, or data from another table. Thanks! Michael