New FTDN July 2017 (FWH 17.07)

[Antonio Linares]

July 2017
=========

* FWMARIADB:
- Fix: METHOD SetMsgLang() not working. Fixed.
- Fix: RowSet METHOD EditBaseRecord(): Not working
correctly when a unique field value is changed. Fixed.
viewtopic.php?f=3&t=34289

* New: Class TCalex from Daniel García Gil, with enhancements from
Cristobal Navarro has been included in FWH, with Daniel authorization.
Please review samples\sample01.prg

* BtnBmp: New DATA bBmpNo: It is possible to add 4 bitmaps to BtnBmp
control. The class decides which bitmap to be shown based on the state
of the control i.e., Active, Pressed, MouseOver. If bBmpNo is specified
the bitmap number returned by the codeblock when evaluated with oBtn as
parameter is displayed.
viewtopic.php?f=3&t=34383

* Brush: New DATA lClientArea (default .f.): Resizeable brushes (gradients
and images) are by default resized to fit client rect. If it is required
to resize to fit client area (excluding oTop(oBar), oLeft, oBottom(msgbar),
and oRight), lClientArea may be set to .T.

* Window.prg: Improved method Gradient()
1. Gradient now matches size of client rect
2. Gradient now resizes when window/dialog is resized
viewtopic.php?f=3&t=34373

* XBROWSE:
- bBarGetValid was not working. Fixed. Now working
- Exiting inline EditGet with TAB key is not saving data uniformly. Was
saving character values, not saving dates and integers, saving only
integer part of decimal numbers ignoring decimals. Fixed now.

* XBREPORT: Fixed resource leakage

* TDATABASE:
New Methods:
- Record( [cFieldList], [lNew] ) --> RecordObject for edit/save
Note: RecordObject is TDataRow object
- Edit( [cFieldList], [lNew] ) --> Edit Dialog for editing/saving a record
- Update( aFlds, aVals ) --> lSuccess
Modifies an existing record, writing aVals to corresponding aFlds
Alternative Syntaxes:
Update( cFieldList, aVals ) --> lSuccess
Update( aVals ) // aVals written to fields 1,2, .etc
Update( aFldVal ) // aFldVal can be 2 dim array of fields and vals
Fields can be by number or names.
- Append() method now returns lSuccess and as usual appends blank
- Append( aFlds, aVals ) --> lSuccess
Appends and writes aVals to aFlds
Alternative Syntaxes are like Update method.
- Record Object handles Calculated columns and Aliased column names
- Method BookMark is now modified as SETGET method.
- New Data: bEdit (format { |oRec|UserEdit( oRec ) } ) for user edit
instead of default edit procedure.
- Enhancement: Method SqlQuery() uses VFPOLEDB is installed for DBFCDX.
- Added DESTRUCTOR method. oDbf := nil closes table and connections.

* MENUS
- Fixed: increase font resources
- Updated function GetnHeightItem(): value initial per default 2.075
Setting a lower value causes an reduction in height of the item,
with limit of GetSysmetrics (15)
Setting a higher value produces a increase in item height
- Added parameter lPop to METHOD AddEdit, for use as MENU POPUP
AddEdit( aColors, cFile, cRes, lPop )
Sample:
Function MyEditMnu( nR, nC, nF, oDlg )
local oMnu
MENU oMnu POPUP
oMnu:AddEdit(,,,.T.)
ENDMENU
ACTIVATE MENU oMnu OF oDlg AT nR, nC
Return oMnu

* COMBOBOX:
Applies to comboboxes created from Source and Resources:
- New clause ITEMHEIGHT <nHt>
Sets height of items displayed in dropdown
- New clause SELHEIGHT <nHt>
Sets height of selection box (get box)
- New clause LISTWIDTH (or) DROPWIDTH <nWidth>
Sets width of drop down list box.
- These settings can also be changed/reset at runtime
using the SETGET datas:
oCbx:nItemHeight := <nNewVal> // NIL resets to default
oCbx:nSelectionHeight := <nNewVal> // NIL resets
oCbx:nDropWidth := <nNewVal> // reset does not work

- New clause [ DIRECTORY <cDirectory> [ATTRIB <nAttr>] ;
[SAYDIR oSay] ]
Displays files in the directory. In this case
aItems is forced empty. Contents of the directory are
displayed in the listbox.
See \fwh\samples\combodir.prg

[Silvio.Falconi]

Antonio,

Class TCalex from Daniel García Gil, with enhancements from
Cristobal Navarro has been included in FWH

Wich are the enhancements from
Cristobal Navarro ?
Sync to Google calendar?
Print week ?

[Antonio Linares]

Silvio,

* New: Class TCalex from Daniel García Gil, with enhancements from
Cristobal Navarro has been included in FWH, with Daniel authorization.
Please review samples\sample01.prg

[Silvio.Falconi]

Dear Antonio,
I saw the sample01.prg

1. there is not the report of week but only the report from date to date
I gave todaniel a test where I tried to bring graphically back to the week. There were a lot of mistakes
Daniel promised me he would do the week's report in graphics mode by reporting every appointment with the colors that the user had assigned to him and the title

2. I not found the syncro with google calendar you promise at Sillian together cristobal and daniel
Cristobal sad me he would do it with Daniel

3. when I create a appointments it not refresh the archive ( the same error made before) and then if I show the week I cannot see the appoinment created . Only if I close sample01.exe and reopen it I can show the appointment

4. there are colors but I cannot change the color appoinment at sampleo1

I saw the version of fjhg, tcalex changed by fjhg

I'm really disappointed because I was expecting more because it was promised at the hotel in sillian last july

Regards

[Antonio Linares]

Silvio,

I have been on holidays for a couple of weeks.

Please wait some days for me to supervise what you are saying, thanks

[richard-service]

Silvio,

I have been on holidays for a couple of weeks.

Please wait some days for me to supervise what you are saying, thanks

Hi Antonio,

I wait this ... syncro with google calendar function with FWH. How long be finish?