Customization to allow users to firm release all jobs on an orde

I've taken all the online classes for the technical side but I don't remember anything about this? I'll go back and look at the self-paced courses to see if there's anything.

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> It's a very simple program (that I've tried to add more poewer to in vain).
> Help explains it well enough.
> If you paid for Vantage training, it was probably briefly mentioned at some point.
> Glad I could help.
> Rob
>
> --- Original Message ---
> From:"rostamthegrey" <rostamthegrey@...>
> Sent:Mon 12/7/09 8:25 pm
> To:vantage@yahoogroups.com
> Subj:[Vantage] Re: Customization to allow users to firm release all jobs on an order
>
> Sounds like exactly what I need! Thank You! So I have built a way to retrieve all of the Jobs. I just need to know how to use the job status maintenance? Also, is there a book or knowledgebase that would have helped me to discover the solution to this issue?
>
> --- In vantage@yahoogroups.com, robertb_versa@ wrote:
> >
> > Why not use job status maintenance (intended for mass firming, engineering and/or releasing)?
> > You can write an advanced search to find all jobs linked to an entered order (and then push firm all).
> > Might not be worth re-inventing the wheel. /:o
> > Rob
> >
> > --- Original Message ---
> > From:"rostamthegrey" <rostamthegrey@>
> > Sent:Mon 12/7/09 6:58 pm
> > To:vantage@yahoogroups.com
> > Subj:[Vantage] Customization to allow users to firm release all jobs on an order
> >
> > My problem is, I can use an adapter to get all the rows, but then I can't figure out how to update. I originally tried just using the oTrans OrderRel table. It updates but it only pulls the currently selected job. Below is my code as it stands now. I just need to be able to make it update the data in the database.
> >
> > Private Sub btnConfirm_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnConfirm.Click
> > Dim myDataView As EpiDataView = CType(oTrans.EpiDataViews("OrderRel"), EpiDataView)
> > Dim whereClause As String = "OrderNum = '" + myDataView.dataView(0)("OrderNum").ToString()+ "'"
> > Dim recSelected As Boolean
> > Dim dsSearch As DataSet
> > dsSearch = SearchFunctions.listLookup(oTrans, "OrderRelSearchAdapter", recSelected, False, whereClause)
> > 'MessageBox.Show(dsSearch.Tables(0).Rows.Count.ToString())
> > Dim I As Int32
> > For I = 0 To dsSearch.Tables(0).Rows.Count - 1
> > If btnConfirm.Text = "Confirm" Then
> > dsSearch.Tables(0).Rows(I)("FirmRelease") = True
> > Else
> > dsSearch.Tables(0).Rows(I)("FirmRelease") = False
> > End If
> > Next
> > If btnConfirm.Text = "Confirm" Then
> > btnConfirm.Text = "Unconfirm"
> > Else
> > btnConfirm.Text = "Confirm"
> > End If
> > End Sub
> >
>
My problem is, I can use an adapter to get all the rows, but then I can't figure out how to update. I originally tried just using the oTrans OrderRel table. It updates but it only pulls the currently selected job. Below is my code as it stands now. I just need to be able to make it update the data in the database.

Private Sub btnConfirm_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnConfirm.Click
Dim myDataView As EpiDataView = CType(oTrans.EpiDataViews("OrderRel"), EpiDataView)
Dim whereClause As String = "OrderNum = '" + myDataView.dataView(0)("OrderNum").ToString()+ "'"
Dim recSelected As Boolean
Dim dsSearch As DataSet
dsSearch = SearchFunctions.listLookup(oTrans, "OrderRelSearchAdapter", recSelected, False, whereClause)
'MessageBox.Show(dsSearch.Tables(0).Rows.Count.ToString())
Dim I As Int32
For I = 0 To dsSearch.Tables(0).Rows.Count - 1
If btnConfirm.Text = "Confirm" Then
dsSearch.Tables(0).Rows(I)("FirmRelease") = True
Else
dsSearch.Tables(0).Rows(I)("FirmRelease") = False
End If
Next
If btnConfirm.Text = "Confirm" Then
btnConfirm.Text = "Unconfirm"
Else
btnConfirm.Text = "Confirm"
End If
End Sub
Why not use job status maintenance (intended for mass firming, engineering and/or releasing)?
You can write an advanced search to find all jobs linked to an entered order (and then push firm all).
Might not be worth re-inventing the wheel. /:o
Rob

--- Original Message ---
From:"rostamthegrey" <rostamthegrey@...>
Sent:Mon 12/7/09 6:58 pm
To:vantage@yahoogroups.com
Subj:[Vantage] Customization to allow users to firm release all jobs on an order

My problem is, I can use an adapter to get all the rows, but then I can't figure out how to update. I originally tried just using the oTrans OrderRel table. It updates but it only pulls the currently selected job. Below is my code as it stands now. I just need to be able to make it update the data in the database.

Private Sub btnConfirm_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnConfirm.Click
Dim myDataView As EpiDataView = CType(oTrans.EpiDataViews("OrderRel"), EpiDataView)
Dim whereClause As String = "OrderNum = '" + myDataView.dataView(0)("OrderNum").ToString()+ "'"
Dim recSelected As Boolean
Dim dsSearch As DataSet
dsSearch = SearchFunctions.listLookup(oTrans, "OrderRelSearchAdapter", recSelected, False, whereClause)
'MessageBox.Show(dsSearch.Tables(0).Rows.Count.ToString())
Dim I As Int32
For I = 0 To dsSearch.Tables(0).Rows.Count - 1
If btnConfirm.Text = "Confirm" Then
dsSearch.Tables(0).Rows(I)("FirmRelease") = True
Else
dsSearch.Tables(0).Rows(I)("FirmRelease") = False
End If
Next
If btnConfirm.Text = "Confirm" Then
btnConfirm.Text = "Unconfirm"
Else
btnConfirm.Text = "Confirm"
End If
End Sub
Sounds like exactly what I need! Thank You! So I have built a way to retrieve all of the Jobs. I just need to know how to use the job status maintenance? Also, is there a book or knowledgebase that would have helped me to discover the solution to this issue?

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Why not use job status maintenance (intended for mass firming, engineering and/or releasing)?
> You can write an advanced search to find all jobs linked to an entered order (and then push firm all).
> Might not be worth re-inventing the wheel. /:o
> Rob
>
> --- Original Message ---
> From:"rostamthegrey" <rostamthegrey@...>
> Sent:Mon 12/7/09 6:58 pm
> To:vantage@yahoogroups.com
> Subj:[Vantage] Customization to allow users to firm release all jobs on an order
>
> My problem is, I can use an adapter to get all the rows, but then I can't figure out how to update. I originally tried just using the oTrans OrderRel table. It updates but it only pulls the currently selected job. Below is my code as it stands now. I just need to be able to make it update the data in the database.
>
> Private Sub btnConfirm_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnConfirm.Click
> Dim myDataView As EpiDataView = CType(oTrans.EpiDataViews("OrderRel"), EpiDataView)
> Dim whereClause As String = "OrderNum = '" + myDataView.dataView(0)("OrderNum").ToString()+ "'"
> Dim recSelected As Boolean
> Dim dsSearch As DataSet
> dsSearch = SearchFunctions.listLookup(oTrans, "OrderRelSearchAdapter", recSelected, False, whereClause)
> 'MessageBox.Show(dsSearch.Tables(0).Rows.Count.ToString())
> Dim I As Int32
> For I = 0 To dsSearch.Tables(0).Rows.Count - 1
> If btnConfirm.Text = "Confirm" Then
> dsSearch.Tables(0).Rows(I)("FirmRelease") = True
> Else
> dsSearch.Tables(0).Rows(I)("FirmRelease") = False
> End If
> Next
> If btnConfirm.Text = "Confirm" Then
> btnConfirm.Text = "Unconfirm"
> Else
> btnConfirm.Text = "Confirm"
> End If
> End Sub
>
It's a very simple program (that I've tried to add more poewer to in vain).
Help explains it well enough.
If you paid for Vantage training, it was probably briefly mentioned at some point.
Glad I could help.
Rob

--- Original Message ---
From:"rostamthegrey" <rostamthegrey@...>
Sent:Mon 12/7/09 8:25 pm
To:vantage@yahoogroups.com
Subj:[Vantage] Re: Customization to allow users to firm release all jobs on an order

Sounds like exactly what I need! Thank You! So I have built a way to retrieve all of the Jobs. I just need to know how to use the job status maintenance? Also, is there a book or knowledgebase that would have helped me to discover the solution to this issue?

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Why not use job status maintenance (intended for mass firming, engineering and/or releasing)?
> You can write an advanced search to find all jobs linked to an entered order (and then push firm all).
> Might not be worth re-inventing the wheel. /:o
> Rob
>
> --- Original Message ---
> From:"rostamthegrey" <rostamthegrey@...>
> Sent:Mon 12/7/09 6:58 pm
> To:vantage@yahoogroups.com
> Subj:[Vantage] Customization to allow users to firm release all jobs on an order
>
> My problem is, I can use an adapter to get all the rows, but then I can't figure out how to update. I originally tried just using the oTrans OrderRel table. It updates but it only pulls the currently selected job. Below is my code as it stands now. I just need to be able to make it update the data in the database.
>
> Private Sub btnConfirm_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnConfirm.Click
> Dim myDataView As EpiDataView = CType(oTrans.EpiDataViews("OrderRel"), EpiDataView)
> Dim whereClause As String = "OrderNum = '" + myDataView.dataView(0)("OrderNum").ToString()+ "'"
> Dim recSelected As Boolean
> Dim dsSearch As DataSet
> dsSearch = SearchFunctions.listLookup(oTrans, "OrderRelSearchAdapter", recSelected, False, whereClause)
> 'MessageBox.Show(dsSearch.Tables(0).Rows.Count.ToString())
> Dim I As Int32
> For I = 0 To dsSearch.Tables(0).Rows.Count - 1
> If btnConfirm.Text = "Confirm" Then
> dsSearch.Tables(0).Rows(I)("FirmRelease") = True
> Else
> dsSearch.Tables(0).Rows(I)("FirmRelease") = False
> End If
> Next
> If btnConfirm.Text = "Confirm" Then
> btnConfirm.Text = "Unconfirm"
> Else
> btnConfirm.Text = "Confirm"
> End If
> End Sub
>