Getting logical row # from a dataset table

[DwaineC]

I can use the dataset.table("MyTable&quot.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]

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

 

[DwaineC]

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

 

[kcj402003]

Dwaine,

I'm trying to do the same thing. What solution did you come up with?

KJ

 

[DwaineC]

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.