New edit table properties (OpenInsight 32-Bit)
At 27 APR 2006 12:50:13PM Gerald Lovel wrote:
After Sprezz informed me of the new ROWLIMIT property (thank you verry much), I searched the documentation for other properties I hadn't used. DUMMYCAPTION worked nicely in one instance, but I think it is old hat to everyone but me. Then I got to – ROWSHADE, EVENROWCOLOR, ODDROWCOLOR.
Wow. I added these properties as form control commands without having to change program code anywhere, and the effect is very pleasing. "Crunk as a mug," as the kids would say. I am satisfied without having these property options integrated into the forms designer.
But I have one tiny nit. At first, I tried to use hex values for the RGB color – \CCFFFF\ for light yellow, for example – but all that displayed was black. Switching to 12582911 produced the correct color effect, but I will bet that no reader wants to do this conversion without a calculator.
Now if I were programming, I could use a function to convert Hex to decimal and insert this conversion into the Set_Property(…) program statement. I added this feature to a form without programming it, however. Instead, I tried to write out the command as
SET_PROPERTY( "WARES_RECEIVERS.LOTS_EDT", "EVENROWCOLOR", "ICONV('CCFFFF','MX' )" )
but command interpretation using "Function( @function… )" or "Call @program(…)" did not extend to expressions included as parameters. Shucks.
Looking at the "ICONV MX, HEX…" topic in the programmer's reference manual, the input parameter for MX is described as "hexadecimal characters" instead of a hexadecimal number. The example says that the output of Iconv( '595A','HEX') is 'YZ'.