FiveTech Software tech support forums

... usadas hasta ahora.. tablas, TarrayData y rowSet... tienen metodos de navegacion y ordenaminento,,,, Navigation: Supports all methods of TDatabase like GoTop,GoBottom,GoTo,Skip,Eof,Bof,LastRec, RecCount,KeyCount,KeyGoTo, etc Also supports aliased methods compatible with ADO MoveFirst,MoveLast,Move,BookMark,AbsolutePosition, ...

... LOCAL nAnno2 := LTrim(Str(Year(Date())))  // year now    // Apre il database    oDbf := TDatabase():Open( , "Lotto", "DBFCDX", .T. )        IF oDbf == NIL        ...

... fault I haven't used listbox (wbrowse) for many years and then listbox doesn't have e style support for win7/win10/win11, it doesn't work with tdatabase, I can't create double headers.... The goal is to increase the size of the thumb on the horizontal scroll bar, so that it visually represents ...

It's strange because in the test I did, that is, in the procedure in a small dialog, everything works perfectly, but when I create an object class with all the functions of the procedure it doesn't work, that is, it doesn't find the data, there's definitely an error somewhere that I can't find. this...

MarcoBoschi wrote:Silvio,
have you some records in which the year of field named "data" is 2024
In the screenshot I see 1971

Bye

yes that is the beginning of the archive, I tried to make a filter in emagdbu

Silvio,
have you some records in which the year of field named "data" is 2024
In the screenshot I see 1971

Bye

...    local   cFilter:= "LTRIM(STR(YEAR(FIELD->DATA)))= '" + ltrim(str(nyear)) + "'"     oDbf:= TDatabase():Open( , cdbfPath+"LOTTO", "DBFCDX", .T. )  oDbf:setorder(1)  oDbf:GoTop()          xbrowser odbf        oDbf:SetFilter(cFilter)  ...

... 0 )   Called from: .\source\function\dbffunc2.prg => FW_ARRAYTODBF( 586 )   Called from: .\source\classes\database.prg => TDATABASE:HB_EXECFROMARRAY( 0 )   Called from: .\source\classes\database.prg => TDATABASE:ARRAYTODBF( 1637 )   Called from: Source\test.prg ...

nageswaragunupudi wrote:

Code: Select all  Expand view

function FW_DbfToArray( cFieldList, bFor )

Give your filter condition in the second parameter ( bFor ) as a codeblock

Thanks

Code: Select all  Expand view

function FW_DbfToArray( cFieldList, bFor )

Give your filter condition in the second parameter ( bFor ) as a codeblock

I need to create on Memory an array from a database I need to insert several conditions Now I tried making a filter oConteggio:=TDatabase():Open( , "Lotto", "DBFCDX", .T. ) IF nLastRecords > 0 nInit:=oConteggio:lastrec()-nLastRecords nEnd:= oConteggio:lastrec() ENDIF ...

Hello, so rewriting tdatabase() class to use to use rowset should work? Maybe someone have done it already? Seems like logical path for me from dbf to Mariadb for those using tdatabase()... Rowset object would be helpful, I need an ...

Code: Select all  Expand view

oRowSet:FCount()

is available and works exactly like TDatabase FCount()

We tried to make RowSet methods compatible with TDataBase and ADO RecordSet.

Please let us know if you want more, we will provide you natively with RowSet object.

Hello, have somebody tryed to rewrite tdatabase() class to use RowSet object instead of dbf file? For sample METHOD FCount() INLINE ( ::oRc:FCount() ) //where ::oRc is rowset object created for this object instead of METHOD FCount() INLINE ( ...

... get a match, and thus no replacement. FOR ALL OTHER DATA TYPES this process works fine. I did not write the original function ( an extension of tDatabase ). I need to find a way to be able to do a replace for the numeric fields. I've spent a long time trying different things. Every other option ...