Page 1 of 1
Question xbrowse..
Posted: Thu Apr 24, 2008 10:48 pm
by leandro
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
Posted: Thu Apr 24, 2008 10:52 pm
by nageswaragunupudi
oRs:AbsolutePosition := nRequiredRowNo
oBrw:Refresh()
Posted: Fri Apr 25, 2008 12:46 am
by Rick Lipkin
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