FiveTech Software tech support forums

... = { || oRS1Cli:RecordCount } oBrow:bGoTop = { || oRS1Cli:MoveFirst() } oBrow:bGoBottom = { || oRS1Cli:MoveLast() } oBrow:bSkip = { | nSkip | Skipper( oRs1Cli, nSkip ) } oBrow:lcellstyle := .f. oBrow:nlinestyle := 2 oBrow:nclrpane := { || iif( ( oRS1Cli:AbsolutePosition / 2 ) - INT( oRS1Cli:AbsolutePosition ...

... in older Network it was slow to open a DBF, read/write and close it. but that have change very slow are TBrowse & Co which use a "Skipper" to navigate. Spezial when using FILTER without SCOPE / Index it can very slow on big Database and make much Traffic btw. same with SQL ...

hi

as James say you are using FILTER on "Skipper" of "Browse"
DbSetFilter() will use hole DBF and "Skipper" will test until EOF() / BOF()

i use DbSetFilter() only with SCOPE
SCOPE will "limit" EOF() / BOF()

... LISTBOX olbm FIELDS (oDbf:calias) ->NAPE ID 101; ON DBLCLICK (lacepto:= .t.,odlg:end()) of odlg olbm:setfocus() olbm:bSkip := { | nRecs | odbf:Skipper( nRecs ) } 1-Quite esta parte olbm:bSeek := {|lRet| olbm:DbfSeek(.T.) } oLbm:bkeydown := {|nkey,nflags| iif(nKey = VK_RETURN, nBut:setfocus(),.f.)} ...

https://mybergland.com/fwforum/seamap.jpg Hello friends, we have now ready two version of SEAMAP for mod harbour. One based on functions and one in OOP style. SEAMAP shows all functionality you need to create a dbf file, browse the data, add, edit and delete records. SEAMAP is a web pag...

https://mybergland.com/fwforum/seamap.jpg Hello friends, we have now ready two version of SEAMAP for mod harbour. One based on functions and one in OOP style. SEAMAP shows all functionality you need to create a dbf file, browse the data, add, edit and delete records. SEAMAP is a web pag...

https://mybergland.com/fwforum/seamap.jpg Hello friends, we have now ready two version of SEAMAP for mod harbour. One based on functions and one in OOP style. SEAMAP shows all functionality you need to create a dbf file, browse the data, add, edit and delete records. SEAMAP is a web pag...

... method 89. Skip( nRecords ) Skips nRecords, executes bBof or bEof when necessary and loads field values into ::aBuffer if ::lBufer is true. 90. Skipper Internal Used by XBrowse, This method is not useful directly in application. 91. SqlQuery( cSql, lExecute, lCompact ) 92. UnLock() Removes all ...

Norberto,

Try using your database with fwh\samples\testbrw.prg and see if that is working.

Possibly your program is working but showing an unexpected result, i.e. there is a filter that filters out all the data.

Let us know what you find.

Regards,
James

... Here is some ListBox code I used before xBrowse and ADO ... and not tData .. I don't know if this code will help you ?? I have included the Skipper function as well. Rick Lipkin @ 0,0 LISTBOX oBrw FIELDS   ;      oRs:Fields("novellid"):Value,;      substr( trim(oRs:Fields("lname"):Value)+", ...

Norberto,

TData inherits the skipper() method from TDatabase (it doesn't have one of it's own), so any changes would have been in TDatabase. I haven't use TWBrowse in years so I haven't noticed your problem.

Do you know what version your app was previously compiled with when it was working?

James

HI, i have a old appl, i try compile with fwh17.04 and my twbrowse is empty, without records, i use twbrowse, tdata (from james), something is changed ? i dont change the code of this appl for years.

this code Works or something is changed:

oLbx:bSkip := { | nRecs | oCCBA:skipper( nRecs ) }

thanks

... one skip. Mouse Click causes full refresh. Keeping this in mind, I provide you here a test program, which shows continuously how many times the Skipper is called. #include "fivewin.ch"REQUEST DBFCDX#ifndef __XHARBOUR__   #xtranslate DbSkipper => __DbSkipper#endifstatic nSkipperCalls ...

... click it changes to the new name. I am using FWH 15.05/xHarbour Update 2: OK, I found the problem. Replace this line: oBrw:bSkip:= {|nRecs| oCust:skipper(nRecs) } With this: oBrw:setoDBF( oCust ) And all is OK. My bad! James

... oArray:aData ), without it, xbrowse shows more data that array has, and the navigation work bad, I think I need to review some method like EOF or skipper. regards Marcelo 1) I have just posted a sample SetXBrowse() method calling SetArray() internally. We have done this because the internal data ...