FiveTech 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=3t=32737

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

&