Question xbrowse..

Question xbrowse..

Postby leandro » 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

[ Embarcadero C++ 7.60 for Win32 ] [ FiveWin 23.07 ] [ xHarbour 1.3.0 Intl. (SimpLex) (Build 20230914) ]
User avatar
leandro
 
Posts: 1669
Joined: Wed Oct 26, 2005 2:49 pm
Location: Colombia

Postby nageswaragunupudi » Thu Apr 24, 2008 10:52 pm

oRs:AbsolutePosition := nRequiredRowNo
oBrw:Refresh()
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10624
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Postby Rick Lipkin » 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
User avatar
Rick Lipkin
 
Posts: 2665
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Jimmy and 85 guests