New FTDN June/Junio 2019 (FWH 19.06)
Posted: Thu Jul 11, 2019 6:14 pm
June 2019
=========
* XBrowse:
- New Data bOnResizeCol: Evaluated after completion of resize of a column
by mousedrag by the user with parameters Column object and previous width
before resize.
eg: oBrw:bOnResizeCol := { |oCol,nPrevWidth| <action> }
- When lFastDraw is .t., the text is painted opaquely in some caes, from
FWH1905. Fixed.
- Incremental filters are not cleared when the browse exits. Fixed.
- It is a known issue that incremental filters replace the existing filters,
instead of being additional filters.
This was fixed in FWH1905 for DBFs and further improved now.
In this version, this is fixed for MariaDB rowsets also.
* FW_Record: (TDatarow class)
- Methods Paste( [hRec] ) and CopyFrom( oOtherRec ) are enhanced by adding
a new parameter acFieldList. If specified, only fields in the list are
pasted/copied from.
Usage:
oRec:Paste( [hRec], [acFields] ) or oRec:Paste( [acFields] )
oRec:CopyFrom( oOtherRec, [acFields] )
- Fix: ADO: adLongVarChar fields are not read. Fixed
* EasyReport: QR_code is now printed to fit the size of the area designed.
* Compatibility with xharbour.com: Usage of C function "isalnum(" is resulting
in unresolved externals ___mb_curmax, __isctype, __pctype. This is not an
issue with other compilers. Fixed by replacing "isalnum(" function with
HB_ISALNUM()
* New function FW_StripComments( cPrg ): All comments in a program text are
substituted by spaces, retaining line numbers.
* Enhancement: FW_At(...):
- Parameter lSkipStrings can be a character string
containing any or some of ', ", [. Only the characters specified are
considered as quote characters.
- Parameters cnStart and cnEnd can be strings also. If specified nStart
search starts after cStart in cString, if found and otherwise from 1.
nEnd is character befpre cEnd if found and otherwise length of cString.
* TGET: When using picture clause @K, get is not cleared when the get gets
focus second time onwards. Fixed.
* TGRAPH:
- New DATAs:
DATA cFont // cFaceName Font Base
DATA nHFont // nHeight Font
DATA nPorcY INIT 4600 // For Print Image aspect
DATA nPorcX INIT 4000 // For Print Image aspect
- Modified: METHOD Save2XLS( nTypeGraph )
Added type of Graph to export
https://msdn.microsoft.com/en-us/librar ... =office.12).aspx
viewtopic.php?f=6&t=37335#p223075
- New METHODs:
METHOD PrintGraph( lPrev )
METHOD GraphZoom()
METHOD SetArrayFonts( aF )
- Added: Export to Excel and Print ( "To Screen" and "To Printer" ) in PopMenu METHOD
- TBtnBmp: New classdata lLegacyLookLeftRight INIT .f.
When using clauses LEFT/RIGHT, the bitmaps are fully LEFT/RIGHT aligned.
In very old versions and bmp and prompt are together and centered.
This option displays in the old style.
See the post:
viewtopic.php?f=3&t=37400
- MDICHILD window: In a Unicode application, mdichild window is not displaying
Unicode title correctly. Fixed.
viewtopic.php?f=3&p=223612#p223612
- Native support for using Image2PDF library for the programmers now using
the library or future users, without the need to develop their own
interfaces. This works only with 32-bit versions.
It is required that "Image2PDF StdCall.dll" be downloaded and placed in the
exe folder.
It is enough to set these class variables initially to use Image2pdf library
to generate PDFs.
TPrinter():lUseI2PDF := .T.
TPrinter():cI2PDFlicence := nil // assign your licence
If licence is not entered, the pdf generated will have a watermark that it is
an Evaluation copy.
Sample: \fwh\samples\img2pdf.prg
- Printer.prg: Creation of PDF silently was earlier using function FWPreviewToPDF(),
which was creating large PDFs. Now if MSWord is installed, PDF is created using
Word and if not using FWPreviewToPDF().
* function FW_CdxCreate() now restores the previous order after indexing.
* Enhancements to FW_DbfToExcel( cFieldList, bFor, bWhile, nNext, nRec, lRest, cSaveTo )
fwh\source\function\dbfunc2.prg
- cFieldList can also be an array of field names/expressions.
- It is possible to sepcify header other than the expression by specifying
"QTY * PRICE AS AMOUNT". Value of QTY * PRICE will be exported with the heading
"AMOUNT".
- Text and decimal numbers are formatted. As a result, char fields with all numbers
with leading zeros are not exported as numbers but as text only.
viewtopic.php?f=3&t=37425
- Excel does not accept empty dates or dates earlier than 1900-01-01. Such date
values result in runtimerror. Now, in such cases the dates are exported as text.
* function aGetFiles() was crashing when select large number of files. Fixed.
=========
* XBrowse:
- New Data bOnResizeCol: Evaluated after completion of resize of a column
by mousedrag by the user with parameters Column object and previous width
before resize.
eg: oBrw:bOnResizeCol := { |oCol,nPrevWidth| <action> }
- When lFastDraw is .t., the text is painted opaquely in some caes, from
FWH1905. Fixed.
- Incremental filters are not cleared when the browse exits. Fixed.
- It is a known issue that incremental filters replace the existing filters,
instead of being additional filters.
This was fixed in FWH1905 for DBFs and further improved now.
In this version, this is fixed for MariaDB rowsets also.
* FW_Record: (TDatarow class)
- Methods Paste( [hRec] ) and CopyFrom( oOtherRec ) are enhanced by adding
a new parameter acFieldList. If specified, only fields in the list are
pasted/copied from.
Usage:
oRec:Paste( [hRec], [acFields] ) or oRec:Paste( [acFields] )
oRec:CopyFrom( oOtherRec, [acFields] )
- Fix: ADO: adLongVarChar fields are not read. Fixed
* EasyReport: QR_code is now printed to fit the size of the area designed.
* Compatibility with xharbour.com: Usage of C function "isalnum(" is resulting
in unresolved externals ___mb_curmax, __isctype, __pctype. This is not an
issue with other compilers. Fixed by replacing "isalnum(" function with
HB_ISALNUM()
* New function FW_StripComments( cPrg ): All comments in a program text are
substituted by spaces, retaining line numbers.
* Enhancement: FW_At(...):
- Parameter lSkipStrings can be a character string
containing any or some of ', ", [. Only the characters specified are
considered as quote characters.
- Parameters cnStart and cnEnd can be strings also. If specified nStart
search starts after cStart in cString, if found and otherwise from 1.
nEnd is character befpre cEnd if found and otherwise length of cString.
* TGET: When using picture clause @K, get is not cleared when the get gets
focus second time onwards. Fixed.
* TGRAPH:
- New DATAs:
DATA cFont // cFaceName Font Base
DATA nHFont // nHeight Font
DATA nPorcY INIT 4600 // For Print Image aspect
DATA nPorcX INIT 4000 // For Print Image aspect
- Modified: METHOD Save2XLS( nTypeGraph )
Added type of Graph to export
https://msdn.microsoft.com/en-us/librar ... =office.12).aspx
viewtopic.php?f=6&t=37335#p223075
- New METHODs:
METHOD PrintGraph( lPrev )
METHOD GraphZoom()
METHOD SetArrayFonts( aF )
- Added: Export to Excel and Print ( "To Screen" and "To Printer" ) in PopMenu METHOD
- TBtnBmp: New classdata lLegacyLookLeftRight INIT .f.
When using clauses LEFT/RIGHT, the bitmaps are fully LEFT/RIGHT aligned.
In very old versions and bmp and prompt are together and centered.
This option displays in the old style.
See the post:
viewtopic.php?f=3&t=37400
- MDICHILD window: In a Unicode application, mdichild window is not displaying
Unicode title correctly. Fixed.
viewtopic.php?f=3&p=223612#p223612
- Native support for using Image2PDF library for the programmers now using
the library or future users, without the need to develop their own
interfaces. This works only with 32-bit versions.
It is required that "Image2PDF StdCall.dll" be downloaded and placed in the
exe folder.
It is enough to set these class variables initially to use Image2pdf library
to generate PDFs.
TPrinter():lUseI2PDF := .T.
TPrinter():cI2PDFlicence := nil // assign your licence
If licence is not entered, the pdf generated will have a watermark that it is
an Evaluation copy.
Sample: \fwh\samples\img2pdf.prg
- Printer.prg: Creation of PDF silently was earlier using function FWPreviewToPDF(),
which was creating large PDFs. Now if MSWord is installed, PDF is created using
Word and if not using FWPreviewToPDF().
* function FW_CdxCreate() now restores the previous order after indexing.
* Enhancements to FW_DbfToExcel( cFieldList, bFor, bWhile, nNext, nRec, lRest, cSaveTo )
fwh\source\function\dbfunc2.prg
- cFieldList can also be an array of field names/expressions.
- It is possible to sepcify header other than the expression by specifying
"QTY * PRICE AS AMOUNT". Value of QTY * PRICE will be exported with the heading
"AMOUNT".
- Text and decimal numbers are formatted. As a result, char fields with all numbers
with leading zeros are not exported as numbers but as text only.
viewtopic.php?f=3&t=37425
- Excel does not accept empty dates or dates earlier than 1900-01-01. Such date
values result in runtimerror. Now, in such cases the dates are exported as text.
* function aGetFiles() was crashing when select large number of files. Fixed.