FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Question xbrowse..
Posts: 1818
Joined: Wed Oct 26, 2005 02:49 PM

Question xbrowse..

Posted: Thu Apr 24, 2008 10:48 PM

Friends of the forum have good day, someone of chance can explain to me since(as,like) I can do to position myself in a specific record inside a xbrowse?
Slightly this way as a dbtop (), but from ADO.

In advance thank you..

Pardon for my Englishman is a translation

Saludos
LEANDRO AREVALO
Bogotá (Colombia)
https://hymlyma.com
https://hymplus.com/
leandroalfonso111@gmail.com
leandroalfonso111@hotmail.com

[ Turbo Incremental Link64 6.98 Embarcadero 7.70 ] [ FiveWin 25.01 ] [ xHarbour 64 bits) ]
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Question xbrowse..

Posted: Thu Apr 24, 2008 10:52 PM

oRs:AbsolutePosition := nRequiredRowNo
oBrw:Refresh()

Regards



G. N. Rao.

Hyderabad, India
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM

Question xbrowse..

Posted: Fri Apr 25, 2008 12:46 AM

Leandro

Using a absoluteposition may yield un-expected results .. especially depending on how you open your recordset .. be careful here.

I would HIGHLY recommend you generate a unique rowid for each record in your table and make it a 'primary key'.

If you are searching for a table condition .. interogate the rowid and store it to a variable or a temp table .. then read your temp table and go find your row as in :

TEMP->ROWID := oRs:Fields("rowid"):Value
...
...
...

cROWID := TEMP->ROWID
oRsMoveFirst()
oRs:Find( "rowid = '"+cROWID+"'" )

Don't know if you can adapt this to your situation .. thought it was worth mentioning.

Rick Lipkin

Continue the discussion