Search found 18 matches: aliased

Return to advanced search

New FTDN February/Febrero 2018 (FWH 18.02)

... ::bAction, Self, nRow, nCol, nFlags ) * FWMARIAROWSET:(MySQL) RowSet object now correctly recognizes initial sort order when sort clause includes aliased fields also. Example: When sql is "select fld1 as col1,fld2 as col2 from table t order by col2", initial order is recognized correctly ...
by Antonio Linares
Fri Mar 09, 2018 12:01 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN February/Febrero 2018 (FWH 18.02)
Replies: 0
Views: 1337

Re: Database - 17.07 - Problems

... creating TDataRow object which has been working for years. It just makes the creation simple and enhancement is that it now covers virtual and aliased columns also. In any case you are not using TDataRow. If you are using TRecord class it should work the same way as before. We shall be glad ...
by nageswaragunupudi
Fri Aug 18, 2017 7:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Database - 17.07 - Problems
Replies: 84
Views: 11871

New FTDN July 2017 (FWH 17.07)

... ) --> 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 ...
by Antonio Linares
Sun Aug 13, 2017 8:19 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN July 2017 (FWH 17.07)
Replies: 5
Views: 2878

TDatabase class WIKI

... ) --> 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 ...
by nageswaragunupudi
Wed Aug 02, 2017 7:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: TDatabase class WIKI
Replies: 4
Views: 745

FWH 17.05: Support for (x)Harbour PostGre libs

... only limited data types. FWH extends support for byinary (bytea) and timestamp datatypes. Basic (hb)pgsql library also can not modify sql with aliased field names and join queries. FWH adds that support. FWPG_Structure( oQry ) --> Extended structure info. Users of FWH 17.05, if interested ...
by nageswaragunupudi
Thu Jun 08, 2017 8:26 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 17.05: Support for (x)Harbour PostGre libs
Replies: 0
Views: 602

Re: Nuevo FWH 16.05

... <original-name in the table> ) --> <alias name in the rowset> Note: Attempting to edit/modify any field values in such Query with aliased field names results in run-time error with other 3rd party libs, but works perfectly with RowSet Field-lengths: In the released version, field ...
by nageswaragunupudi
Sun Jul 17, 2016 12:02 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Nuevo FWH 16.05
Replies: 12
Views: 3731

FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )

... enabled after insert. METHOD Ping() --> lSuccess METHOD BeginTransaction() METHOD CommitTransaction() METHOD RollBack() Note: These methods are aliased to BeginTrans, CommitTrans and RollbackTrans METHOD ListDbs( cMask ) METHOD CreateDB( cDB, [cCharSet] ) METHOD SelectDB( cDB ) METHOD CurrentDB() ...
by nageswaragunupudi
Fri Jul 01, 2016 9:32 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Replies: 76
Views: 28051

Re: ADO RDD xHarbour

Antonio,

AHF wrote:It will be impossible to add rows to the first recordset because of the aliase column?


No, not for the aliased column but for the calculated column.

EMG
by Enrico Maria Giordano
Wed Apr 08, 2015 2:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: ADO RDD xHarbour

... the value <xValue> in the controlling index, rather than in the database. It operates in the current work area, unless it is used in an aliased expression. When DbSeek() finds <xValue> in the controlling index, it returns .T. (true) and positions the record pointer to the corresponding ...
by lucasdebeltran
Mon Apr 06, 2015 2:55 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: xbrowse

... (Articulo)->Name and indexed by it Set the dbRelation by that Field... I would still advise you not to maintain regular indexes (on disk) with aliased expressions and in particular with alias of related tables. Instead you may use temporary indexes in memory for such purposes as and when needed. ...
by nageswaragunupudi
Thu Apr 11, 2013 12:06 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xbrowse
Replies: 9
Views: 2820

New FTDN January 2013 (FWH 13.01)

... function. Before calling the function, the destination table must be opened and should be the default alias. Best way is to call the function aliased eg. DEST->( FW_ExcelToDbf( ... ) ) Parameters: 1. oExcelRange (optional): Valid Excel Range Object. GetExcelRange() function in the olefuncs.prg ...
by Antonio Linares
Sat Feb 02, 2013 5:01 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN January 2013 (FWH 13.01)
Replies: 0
Views: 1530

Re: xBrowse Table records with a subtree

... to load and no amount of memory would handle it. I think xbrowse needs to be expanded to allow creation of a subtree on the fly on an existing aliased (table) xbrowse. I wish the argument will persuade Mr. Rao or whomever is in charge of xbrowse now days. Reinaldo.
by reinaldocrespo
Sat Dec 15, 2012 5:06 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse Table records with a subtree
Replies: 9
Views: 2183

Re: Deshabilitar Boton en Dialogo

... By default, BOF() operates on the currently selected work area. It can be made to operate on an unselected work area by specifying it within an aliased expression (see example below). The SKIP command is the only record movement command that can set BOF() to true (.T.). Saludos
by FranciscoA
Sun Aug 14, 2011 2:53 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Deshabilitar Boton en Dialogo
Replies: 7
Views: 1626

Re: Contar registros

... By default, this function operates on the currently selected work area. It will operate on an unselected work area if you specify it as part of an aliased expression. Examples ¦ This example demonstrates using ORDKEYCOUNT() with various orders: USE customer // Assume 1000 total records, // 500 ...
by Carlos Mora
Tue Jul 19, 2011 9:18 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Contar registros
Replies: 4
Views: 1105

Re: XBROWSE : Error in method Delrepos

... automatically. I did not encounter any problems because by habit since years, I do not use local or static variables ( or any variables ) or aliased expressions in my filter and index expressions. I realized that this modification has become a great irritant to the programmers who use local ...
by demont frank
Mon Mar 30, 2009 3:33 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSE : Error in method Delrepos
Replies: 22
Views: 3563
Next

Return to advanced search