New FTDN August/Agosto 2013 (FWH 13.08)

[Antonio Linares]

August 2013
===========

* Fix: function GetTasks() works on Windows XP, 7 and 8 again:

viewtopic.php?f=16&t=26973&p=150001#p150001

* New: samples/TestTitr.prg and TestTitr.rc shows how to build a TTitle control
from resources:

viewtopic.php?p=150102#p150102

* New: samples\dbcre8.prg lets you create any size of records DBF for your testings:

viewtopic.php?f=3&t=27037

* Fix: Page number in report creation dialogbox was not shown. Now it is ok.

* Fix: rpreview.prg: Fixed display of unnecessary message "No .doc manipulation
software installed" while exporting to word.

* Enhancement: function cValToStr( nil ) now returns "" instead of "nil". Such case
normally arise in case of SQL Tables with NULL values. For the convenience of
programmers who are not providing defaults for NULL values, this modification is made.

* Enhancement: Enhanced Class TDataRow. Now assignment of wronge datatype raises
datatype error. Type check is relaxed for arrays and sqlite. If the programmer
desires to relax type check he may set data :lTypeCheck to .F.

* New: function GetNtpDate() retrieves the internet "time" from a time server.
Please review samples\itime.prg:

http://fivetechsupport.com/forums/viewt ... 96#p150496

* Fix: Class TGet Method LButtonUp() was not considering click beyond the rightmost
text (and pressing Delete after), now it is ok:

viewtopic.php?p=150551#p150551

* New: Command ADOCONNECT <ocn> [TO] <cdbms> [<srv:SERVER,HOST> <cServer>] ;
[ <cat:CATALOG,DATABASE> <catalog> ] [ USER <usr> ] [ PASSWORD <pwd> ]
in fwsqlcmd.ch. Including adodef.ch in turn includes fwsqlcmd.ch

Usage:
ADOCONNECT oCn TO MSSQL SERVER localhost CATALOG FWH USER SA PASSWORD 12345
ADOCONNECT oCn TO MYSQL SERVER localhost DATABASE FWH USER root PASSWORD testpw
ADOCONNECT ocn TO c:\fwh\samples\xbrtest.mdb
ADOCONNECT oCn TO c:\fwh\samoles\tutor01.db

* Enhancement: Class TXBrowse rows painting properly paints the row frame on the
right side.

* New: function FWCheckExpression( cExpression ) --> lOk
function FWArgsList( oError ) --> cArgs
function FWExpBuilder( cExpression, oRs ) --> cExpression

* New: ADO functions:
function FWAdoDelRecord( oRs ) --> lSuccess
function FWAdoFieldType( oRs, n ) --> cType (xbase type)
function FWAdoFieldDec( oRs, n ) --> nDecs (xbase)
function FWAdoFieldSize( oRs, n ) --> nSize (xbase)
function FWAdoLoadRecord( oRs ) --> aRecord
function FWAdoSaveRecord( oRS, aRecord, nRecNo ) --> nil
function FWAdoStruct( oRs ) --> aStruct
function FWAdoFieldStruct( oRs, n/cname/ofield) or (oField)
-> field strut info { cName, cDbtype, nDblen, nDbdec, nAdotype, lReadwrite }
function FW_AdoExportToDBF( oRs, cDbfName, [lEditStruct] ) --> lSuccess

* Fix: XBrowse. While editing numeric values without specifying picture clause
decimal part is not editable. (only when compiled with Harbour).
Implemented workaround for this issue.

* Enhancement: New Class TTreeView Method Notify() and new DATA bExpanded. Please
review samples\classtree.prg

viewtopic.php?p=151105#p151105

* Fix: function CreateMdiWindow() used from Class TMdiChild was exchanging nTop and
nLeft coordinates. Now it is ok.

* New: Class TWindow DATA oToolTip. If a C5 Tooltip is created and assigned to such
DATA then FWH automatically uses it. Please review FWH/samples/c5toolti.prg

* Enhancement: XBrowse: When in MultiSelect mode, pressing Ctrl-A selects all rows.

* New: xbrowse.prg: New functions XbrEditMemo(), XbrHexEdit() and XBrImageEdit() to
provide enhanced Memo field editing capabilities.
At present when a memo field contains RTF,GTF data, indication is provided.
When memo data contains image data, text data or other binary data, the data is
displayed in the cell to the extent fits in the cell size. Edit of text data os
provided within the cell area. Non text data can not be editited.
Now, if for a column with cDataType = 'M', nEditType is set to EDIT_BUTTON,
XBrowse automatically provides default edit features.
For text data, RTf AND GTF, MemoEdit() is used. For Image Data, XBrImageEdit() is
used and for other binary data XbrHexEdit() is used
ImageData: The present image is displayed in a dialog. Options to open a new
image file for replacement of the contents or paste from clipboard are provided.
Options to Undo, Save and Cancel are provided.
XBrHexEdit() provides a simple hex editor.

* Enhancement: Class TMultiGet now allows to edit the max file size for each
Windows version:

http://msdn.microsoft.com/en-us/library ... 47(v=vs.85).aspx

* Enhancement: function MemoEdit() now accepts a codeblock as the first parameter
so very large files can be edited, in example:

MemoEdit( { || MemoRead( "c:\fwh\source\classes\xbrowse.prg" ) } ) --> cEditedText