There are multiple rows in my .tab file in mapinfo. Is there any way to select nth row in mapbasic window of mapinfo?
Select * from 'table' Where RowID = n
If you want it into a selection table of your choice, put the selection into somename
, then browse * from somename
If not, just Browse from selection
edit
This is all from memory, so please play about and also read the online reference manual:
-
-
nps. Seriously though, have a look at the help, as they'll give code samples, you can play with. I'd also recommend 'MapInfo -l'. It's sort of a way of searching through some cracking code samples. – Hairy Aug 11 '11 at 7:50
-
yes I have the user guide I am studying but small things confuse me :( – kinkajou Aug 11 '11 at 7:57
-
well, nps, you'll get answers here as long as you accept them and act in good grace (which I fail to do sometimes). – Hairy Aug 11 '11 at 8:48
Very simple with Fetch:
Fetch rec 125 From Database
will find record #125 in your database...
-
Fetch will only set the cursor at that position and not "select" the actual row. But it does depend on what he wants to do with the row afterwards – Peter Horsbøll Møller Aug 5 '15 at 19:34