Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Getting logical row # from a dataset table
- Thread starter DwaineC
- Start date
.Select statement to return an datarow array of matching records... is there a way to tell me what the original logical record number was for each?
SqueakinSweep
Programmer
Dwaine
So far as Im aware, there is no way to achieve this. The only workaround is to hold the row number in the original table. Usually though you would have a primary key assocaiated with the underlying datatable. I assume you want to be able to go back to the original row for firing updates etc?
Sweep
...if it works dont mess with it
So far as Im aware, there is no way to achieve this. The only workaround is to hold the row number in the original table. Usually though you would have a primary key assocaiated with the underlying datatable. I assume you want to be able to go back to the original row for firing updates etc?
Sweep
...if it works dont mess with it
- Thread starter
- #3
Believe it or not, I'm not even using a backend... I'm using the dataset between a grid and some functions that write to flat files.
I appreciate your answer, and storing the record number in the table was my next call... but, I ended up with a different algorithm for a solution. So great that you took the time to answer, and I appreciate it!
Dwaine
I appreciate your answer, and storing the record number in the table was my next call... but, I ended up with a different algorithm for a solution. So great that you took the time to answer, and I appreciate it!
Dwaine
- Thread starter
- #5
Well, if I actually had to know the logical number, I would probably store it in a column. But the purpose I needed it was to prevent duplicate data entry into a specific column. (Remember, this is not tied to a sql database - I know how to do that.) Anyway, rather than go into my whole issue, I provided myself a work around where I did not need the logical number anymore.
- Status
