Hi
I have a datagrid which I display all lines that I have for a job.
As my lines has revision also, I have to do a filter when I add a new revision for a specific row to see only the last revision in my datagrid.
for example I have the line
1 rev 0
1 rev 1
2 rev 0
2 rev 1
2 rev 2
I display only:
1 rev 1
2 rev 2
My problem is when I add a new revision for a line. For example I add a new revision for the line 2. So I have the line 2 rev 3
It still display the line 2 rev 2. How can I put in a filter (m_DataLayer.DvJobItem.RowFilter = "something here")
to display only the last revision for every line?
I can do the first select in the Select_JobItem Stored procedure. But Once I got it, I can't reconnect to the sqlserver to do a retrieve as the user can work online.
hope that make sense.
Thanks in advance
Rsx02
I have a datagrid which I display all lines that I have for a job.
As my lines has revision also, I have to do a filter when I add a new revision for a specific row to see only the last revision in my datagrid.
for example I have the line
1 rev 0
1 rev 1
2 rev 0
2 rev 1
2 rev 2
I display only:
1 rev 1
2 rev 2
My problem is when I add a new revision for a line. For example I add a new revision for the line 2. So I have the line 2 rev 3
It still display the line 2 rev 2. How can I put in a filter (m_DataLayer.DvJobItem.RowFilter = "something here")
to display only the last revision for every line?
I can do the first select in the Select_JobItem Stored procedure. But Once I got it, I can't reconnect to the sqlserver to do a retrieve as the user can work online.
hope that make sense.
Thanks in advance
Rsx02
