FiveTech Software tech support forums

Updated WIKI of TDatabase class

http://wiki.fivetechsoft.com/doku.php?i ... _tdatabase

This includes new datas and methods added in FWH17.07

* 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.

Hi Nages

Question: Is it possible to use TDatabase only with MySql?

Regards

TDatabase is for DBFs.
TDatabase for MySql is FWMariaRowSet

Hi, Nages.

Thanks,

Is wiki documentation available for FWMariaRowSet?

Regards

Please see

viewtopic.php?f=3&t=32737

We are in the process of including this documentation in WIKI.