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.
61
Programming / strange error 40
« on: March 27, 2019, 04:35:14 AM »
During the import of CSV-files to Excel our program does basically something like this:
At one site the last statement throws an error 40. If I type "run" the program continues without errors.
Is this an issue of our program or an issue of Excel? Where does this error 40 come from, and why is it gone upon continuation?
Code: [Select]
import = sheet'queryTables'add(*connection, *range)
import'adjustColumnWidth = 1
import'textFileCommaDelimiter = 0
import'textFileDecimalSeparator$ = ","
import'textFileThousandsSeparator$ = "."
def object datatypes, %wdx$ + "*VARARRAY"
datatypes'setData(0, 2)
datatypes'setData(1, 2)
datatypes'setData(2, 1)
datatypes'setData(3, 4)
import'textFileColumnDataTypes.put(*datatypes)
This runs fine everywhere, but...At one site the last statement throws an error 40. If I type "run" the program continues without errors.
Is this an issue of our program or an issue of Excel? Where does this error 40 come from, and why is it gone upon continuation?
62
Programming / unique file name
« on: March 18, 2019, 05:52:45 AM »
Is this loop save to generate a unique file name in a multi user environment?
A customer reports issues which can only occur if that loop creates the same file for 2 processes.
A customer reports issues which can only occur if that loop creates the same file for 2 processes.
Code: [Select]
mask$ = "0000000"
extension$ = ".txt"
filePart1$ = path$ + "spoolfile"
counter = 0
repeat
checkFile$ = filePart1$ + str(++counter : mask$) + extension$
serial checkFile$, err = *continue
break
until 0
63
Programming / error 88 with sizer buttons
« on: February 08, 2019, 09:41:26 AM »
With PxPlus V14 locally installed on a Windows system we see several error messages like this one:
_WP_PROPERR:LBXSIZER HOVERTEXTCOLOR$ White Error #88: Invalid/unknown property name 37100 *winproc.dsp
This does not happen with WindX. What are we missing?
_WP_PROPERR:LBXSIZER HOVERTEXTCOLOR$ White Error #88: Invalid/unknown property name 37100 *winproc.dsp
This does not happen with WindX. What are we missing?
64
Wish List / stop *plus/jrnl/apply
« on: January 23, 2019, 04:10:58 AM »
Looks like *plus/jrnl/apply can only be stopped while it is idle.
We're currently re-applying some journal files. As long as the apply program hasn't reached the end of the latest journal it is not looking for the apply.stop file. We use PxPlus V14.
We would like to have the apply program look for the stop file after 100 records or so. May be a parameter in jrnlapply.ini makes sense.
We're currently re-applying some journal files. As long as the apply program hasn't reached the end of the latest journal it is not looking for the apply.stop file. We use PxPlus V14.
We would like to have the apply program look for the stop file after 100 records or so. May be a parameter in jrnlapply.ini makes sense.
65
Programming / set windows titlebar color
« on: January 10, 2019, 04:42:04 AM »
I'm looking for a way to set sereval colors in the standard window titlebar using PxPlus program logic.
These are text color, background color and if possible the color of the min /max icons.
Does someone know how to do this?
These are text color, background color and if possible the color of the min /max icons.
Does someone know how to do this?
66
Programming / draw button as empty rectangle
« on: January 09, 2019, 10:17:38 AM »
I want to create a button with my own program logic (not nomads). What is necessary to make it look like an empty rectangle?
btnCcl= 10501
button btnCcl, @(10, 10, 10, 1.5)="&Cancel",opt="F"
btnCcl'borderColor$ = "DARK GRAY"
btnCcl'hoverTextColor$ = "WHITE"
btnCcl'hoverBackColor$ = "DARK GRAY"
I'm missing the border.
btnCcl= 10501
button btnCcl, @(10, 10, 10, 1.5)="&Cancel",opt="F"
btnCcl'borderColor$ = "DARK GRAY"
btnCcl'hoverTextColor$ = "WHITE"
btnCcl'hoverBackColor$ = "DARK GRAY"
I'm missing the border.
67
Programming / delete empty nodes from treeview listbox
« on: December 19, 2018, 04:04:51 AM »
I want to recursively delete empty nodes from a treeview listbox after deleting a leaf item.
What is the smartest way to do this?
What is the smartest way to do this?
68
Programming / missing rollback on channel close
« on: November 16, 2018, 07:45:29 AM »
There seems to be a problem with [mysql] and pending transactions. If a [mysql] channel is closed with a pending transaction, then no rollback is performed. A [odb] channel behaves correctly. Is there an OPT-parameter to correct this?
Sample program attached.
Sample program attached.
69
Nomads / titlebar has impact on resize actions
« on: November 15, 2018, 03:12:17 AM »
After defining a titlebar panel as a library default the resize actions change.
The environment is PxPlus V14, SCS, Win10
The environment is PxPlus V14, SCS, Win10
- The window isn't maximized by double clicking the titlebar any more. (I think that has been reported before.)
- The resize corner (bottom right) is drawn but not active(?). The only way to resize a window is to move the mouse over the window border on the right hand side. Despite the cursor shape you can resize the window in all directions now. All other borders are disabled.
In the Data Dictionary the resize corner works, but the top and left borders don't. That's why I see a relation between menubar and titlebar. Our panels don't use menubars, they only use titlebar panels and statusbars. - Only the upper half of a statusbar is displayed in a maximized window with the taskbar option "small buttons in taskbar" enabled.
70
Wish List / define query button bitmap by expression
« on: November 15, 2018, 02:06:40 AM »
In the last days I would have enjoyed to define the query button bitmap by an expression like %qryImgCalendar$ or %qryImgFolder$. There are many queries which need a different bitmap than defined in %nomads'qry_btn$.
I'd like to have that option in the future.
I'd like to have that option in the future.
71
Programming / journal files size issue
« on: November 05, 2018, 02:37:37 AM »
Every now and then I see this message in send.log:
** Journal 314 send error - Receiving system file is larger than host - stopping
I don't understand, what it wants to tell me. The file journal.314 has 10937034 bytes on both sides. The pointer value in apply.sts is 10937014. The difference of 20 bytes makes me wonder. Maybe these are the result of some system_jrnl swap issues over the weekend.
The main problem is to get the journal transfer running again, as the sending process constantly stops with this error message.
** Journal 314 send error - Receiving system file is larger than host - stopping
I don't understand, what it wants to tell me. The file journal.314 has 10937034 bytes on both sides. The pointer value in apply.sts is 10937014. The difference of 20 bytes makes me wonder. Maybe these are the result of some system_jrnl swap issues over the weekend.
The main problem is to get the journal transfer running again, as the sending process constantly stops with this error message.
72
Nomads / change caption using titlebars
« on: October 29, 2018, 05:57:56 AM »
I encounter issues when changing the window caption while using titlebars.
As a fonted text with =px_titlebar_caption$ cannot be changed afterwards, I tried many different attribute settings with a multiline control. So far I could not find a satisfying solution. A multiline control always becomes visible if the user clicks and drags into it. The window cannot be moved, if the user clicks on the multiline control.
What is the best practice to change the window caption using titlebars?
As a fonted text with =px_titlebar_caption$ cannot be changed afterwards, I tried many different attribute settings with a multiline control. So far I could not find a satisfying solution. A multiline control always becomes visible if the user clicks and drags into it. The window cannot be moved, if the user clicks on the multiline control.
What is the best practice to change the window caption using titlebars?
73
Nomads / dropbox style
« on: October 18, 2018, 09:15:00 AM »
After moving to Win10 I see the look of dropboxes differ between PxPlus V14 and Win10. Is there a way to make the PxPlus dropboxes look like Win10 dropboxes?
74
Programming / slow msgbox
« on: October 10, 2018, 09:02:34 AM »
After moving several client machines to Win10 we see slow message boxes on all these clients. It turns out that all types of msgbox are drawn instantly as long as no title text is used. The delay is round about 1 second.
instant draw
msgbox "A"
msgbox "A","","?,YESNO",a$
slow draw
msgbox "A","A"
msgbox "A","A","?,YESNO",a$
instant draw
msgbox "A"
msgbox "A","","?,YESNO",a$
slow draw
msgbox "A","A"
msgbox "A","A","?,YESNO",a$
75
Programming / provide many PNGs to WindX
« on: October 05, 2018, 10:24:22 AM »
We're going to redesign the front ends of our applications, which will require many PNGs. In order to reduce network traffic I'm looking for a way to put these files into a container file (DLL, ZIP or whatsoever), copy it to the client and use them from within that container.
I tried *plus/dll/maint without avail. As this tool cannot open oldimages.dll, I have doubts whether that will work.
What options are available with SCS and PxPlus V14?
I tried *plus/dll/maint without avail. As this tool cannot open oldimages.dll, I have doubts whether that will work.
What options are available with SCS and PxPlus V14?