FiveTech Software tech support forums

... and duplicate rows are updated with the values in the source table. - RowSet: New method: oRs:ResyncWhere( cWhere ) or oRs:ResyncWhere( cField, uVal ) Resyncs only one record satisfying the condition. if the record is not already in the rowset, it is appended to the rowset. - RowSet: oRs:WhereLikeCurrentRow() ...

... New Method: XbrAddColumn( oBrw, cCol, cHeader ) - New: RowSet New Method: oRs:ResyncWhere( cwhere ) --> lSuccess or oRs:ResyncWhere( cFldName, uVal ) --> lSuccess a) cWhere condition should resolve to a single record. b) If cwhere resolves to a record already in the rowset, record pointer ...

... You posted : Please go to METHOD AdoIncrSeek and locate the following line: do case case cType == 'C' Change it as do case case cType == 'C' .or. uVal == nil Well with this modification incremental filters on numeric and date columns may fail. In my tests, DATE and NUMERIC - seek is not working ...

... triggered by pressing a key Return value of the codeblock: a) NIL: If the codeblock returns nil, XBrowse does not take any action on its own. b) uVal: If the codeblock returns any value other than nil, XBrowse assigns that value to the column and saves it. If the intention of the programmer is ...

Bien, te cuento lo que se me ocurre Como el DbSeek( uval, .T. ) se sitúa en el valor superior al buscado, coge la diferencia con el anterior y posterior y compruebas cuál es el más aproximado Se me debe escapar algo que no te he entendido porque seguro ...

... ) METHOD SaveToDBF( tablename, [lForUpdate] ) METHOD UploadFromAlias( cTable, cSrcFieldList, cDstFieldList, [lUpdateIgnore] ) METHOD ValToSQL( uVal ) METHOD FieldsAndValsToSQL( aFields, aVals, lWhere ) METHOD Close() or End() Important Methods Explained: MEHOD CreateTable(cTable, aStruct, [lAddAutoInc], ...

... thanks to Mr Rao and Fwh support! #include "fivewin.ch" FUNCTION Main() local oExcel, oBook, oSheet, oWnd, oClp local nRow, nCol, nCols, uVal, uVal2 FW_SetUnicode( .t. ) DEFINE WINDOW oWnd oClp := TClipboard():New() USE "AA_CHN" GO TOP nCols := FCount() oExcel := ExcelObj() ...

... and modify struct NONCLIENTMETRICS Parameters GETNONCLIENT( nPos ) -> look nPos in the struct NONCLIENTMETRICS Parameters SETNONCLIENT( nPos , uVal, bActWinIni ) - SETWHSCROLL( hWnd , nPos , nVal, ActWinIni ) will modify width Scroll bar width and save and update win.ini or not - ISTACTIL() ...

... in fwsqlcmd.ch: Converting single quotes in where clause to double quotes. Fixed now. * New: TXBrowse and TXBrwColumn: Methods AddVar( uVar, uVal ) We can create new DATA for specific instances of browse or column. Eg: oBrw:AddVar( "aMySelect", {} ) AAdd( oBrw:aMySelect, RECNO() ...

En mi anterior codigo, sustituye la linea:     :SetItem( x-1, 1, QTableWidgetItem( uVal:typeToName( uVal:type() ) ) )  por    :SetItem( x-1, 1, QTableWidgetItem( uVal:toString() ) )  y obtienes ...

... and the controll CHECKBOX Before this works REDEFINE CHECKBOX oGet VAR oRec:VOLUME ID 4002 OF oDlg I chek in METHOD dr_FieldPut( cnfld, uVal ) CLASS TDataRow the variable cFldType for field TinyInt return "N" . Application===========   Path and name: D:\prg_SQL\MASTRO\MASTROSQL.EXE ...

... return nil //---------------------------------------------------------- Function MyColToolTip( oBrw, r, c, f, oMouseCol, nMouseRow ) local uBm, uVal if nMouseRow != oBrw:nRowSel uBm := oBrw:BookMark Eval( oBrw:bSkip, nMouseRow - oBrw:nRowSel ) uVal := oMouseCol:Value oBrw:BookMark := uBm else ...

... MyColToolTip( brw,r,c,f,oMouseCol,nMouseRow ) } next ... function MyColToolTip( oBrw, r, c, f, oMouseCol, nMouseRow ) local uVal, nRow, nCol nRow := oBrw:nArrayAt + nMouseRow - oBrw:nRowSel nCol := oMouseCol:nCreationOrder uVal := oBrw:nArrayData[ nRow, nCol ] return cValToChar( ...

... similar but to do so in all cells and is to browse my oQry or this is just to browse with array, try as in the example but it gives me error "UVAL: = oBrw: nArrayData [nRow, nCol] "/ Message not found: TXBrowse: NARRAYDATA, thanks, greetings ... using google translator... :shock: My reply ...

... similar but to do so in all cells and is to browse my oQry or this is just to browse with array, try as in the example but it gives me error "UVAL: = oBrw: nArrayData [nRow, nCol] "/ Message not found: TXBrowse: NARRAYDATA, thanks, greetings ... using google translator... :shock: