PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: 1 ... 8 9 [10]
91
Programming / Re: UCS-2
« Last post by Mike King on May 06, 2022, 02:17:10 PM »
To the best of my knowledge there is no such thing as 16 bit UTF-8.  UTF-8 data is always a string of 8-bit values.

If you want UCS-2 you may be able to do:

   X$=CVS("This is a test","ASCII:UNICODE")

This will provide you a string of 16 bits characters

92
Programming / Re: Need leading zeros in excel
« Last post by Mike King on May 06, 2022, 02:14:41 PM »
The issue is that when Excel is passed text it will analyze the input to see if it might be a number;  If so the cell value will be marked as a number otherwise it would be marked as a string. 

You can see this by simply loading Excel, click on a cell, and enter values such as 007, 0123456, 0000001 -- all will have there leading zeroes stripped. 

You may be able to override this by prefixing the value with a leading apostrophe as is described in the last option on:

https://support.microsoft.com/en-us/office/keeping-leading-zeros-and-large-numbers-1bf7b935-36e1-4985-842f-5dfa51f85fe7
 
93
Programming / Re: Need leading zeros in excel
« Last post by michaelgreer on May 06, 2022, 09:41:32 AM »
When using excel UI if you put an apostrophe (hex 27) you get leading 0s displayed with no apostrophe. I have successfully added that to my output to get the desired effect in some cases. Other instances it fails, but it is worth a try.
94
Programming / Re: UCS-2
« Last post by michaelgreer on May 06, 2022, 09:25:53 AM »
Thanks Mike. It is not clear to me using the cvs function how I specify 16 bit UTF-8.
95
Programming / Re: UCS-2
« Last post by Mike King on May 06, 2022, 08:11:04 AM »
UCS-2 appears to be similar to 16 bit Unicode which you can generate using the PxPlus CVS function.

It is however odd that any web based system would require UCS-2 data, normally web processes will use UTF-8 thereby keeping all data 8 bits and provides supports for a wider of characters.
96
Programming / UCS-2
« Last post by michaelgreer on May 05, 2022, 05:25:42 PM »
I am having trouble using the SalesForce API and it appears it might be because those endpoints require UCS-2 encoding.  Can anyone verify this, and more importantly does anyone have a function or routine that creates that encoding.

Thanks!
Michael
97
Nomads / Stretchable Embedded Panel on Folder Panel
« Last post by James Zukowski on May 04, 2022, 01:42:52 PM »
We've got an embedded panel that I'm updating to be stretchable on our main panels. The stretching seems to work OK when running (design time doesn't show the stretch). The problem arises when we have a folder on the main panel. Instead of embedding the panel on the main panel, it's embedding on the folder.
Is this a problem, or am I doing something wrong?
Attached a couple of screen shots to show the difference. The only thing different is the Stretchable checkbox. This is all done in Test Mode from the designer.
98
Programming / Re: Report Writer Passing .pvr argument
« Last post by Jon Toomsen on May 03, 2022, 11:57:47 AM »
I'm in some kind of rabbit hole - I'll let it set a bit.
99
Programming / Re: Report Writer Passing .pvr argument
« Last post by Jane Raymond on May 03, 2022, 08:59:38 AM »
Jon,
I opened the report as instructed. The blue triangle in the left corner of the row header cell for the line tells me that the row has variable line height. If I click on the Note$ cell to highlight it, then right click and select Bulk Edit Cell Format, then the display indicates that Word Wrap is turned on for that cell.


What may be confusing things here is that if you right click on the cell and select Cell Format, then Word Wrap, there is no indication whether Word Wrap is on or off. Similarly, when you right click on the row header and highlight Variable Line Height, there is no indication as to the current setting. We enhanced the menus in PxPlus 2021 to add checkmarks to the menus to indicate current selections for the current cell. (If multiple cells are highlighted, checkmarks may not appear if the selection is not consistent across the multiple cells.)

100
Programming / Re: Report Writer Passing .pvr argument
« Last post by Jon Toomsen on May 02, 2022, 04:36:18 PM »
use the following from command prompt or equal then save
process "Design","*rpt/rpt.en","C:\0\t9_timetransactionreport.0022.pvr"
Pages: 1 ... 8 9 [10]