I can use the dataset.table("MyTable".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?
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?
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!
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.