Use JobNum without JobHead and see if that worksx.
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Mon, Oct 29, 2012 at 2:32 AM, Greg Payne <gpayne@...>wrote:
> **
>
>
> It wanted just jobnum in the where clause.
>
> Thanks Much
>
> Greg
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of jose@...
> Sent: Monday, October 29, 2012 1:15 AM
> To: Vantage
> Subject: Re: [Vantage] C# code error
>
>
> Not sure the joblist table has jobhead. Try
> Joblist.jobnum
>
> Sorry its hard to see from my phone and the internet in china sux
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: Greg Payne <gpayne@...<mailto:
> gpayne%40compulink-usa.com>>
> Sender: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Date: Mon, 29 Oct 2012 01:11:39
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><
> vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
> Reply-To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] C# code error
>
> On 905.700C SQL 64bit. I am trying to use code from usdoingstuff to add an
> operation to open jobs. the code compiles, but when I run it I get the
> error below.
> Thanks for your help.
> Greg Payne
>
> Epicor.Mfg.Common.BusinessObjectException was unhandled by user code
> Message=37000: [Microsoft][SQL Server Native Client 10.0][SQL Server]The
> multi-part identifier "JobHead.JobNum" could not be bound.
> Stored Procedure failed execution. See previous errors for more
> information (14958)
> Source=Epicor.Mfg.BO.JobEntry
> StackTrace:
> at Epicor.Mfg.Proxy.JobEntryImpl.GetList(String whereClause, Int32
> pageSize, Int32 absolutePage, Boolean& morePages)
> at Script.btnAddFINAUD_Click(Object sender, EventArgs args) in
> c:\ProgramData\Epicor\svr-eapp-9421\9.05.700C\COMP01\CustomDLLs\App.UD06Entry.UD06Form.EP.COMP01.Customization.Compulink_ADD_FINAUD.CustomCode.7.cs:line
> 172
>
> Code ---------------------------
>
> private void btnAddFINAUD_Click(object sender, System.EventArgs args)
> {
> // ** Place Event Handling Code Here **
>
> bool funBool; //Boolean required by GetList Method
> String outMsg; //String required by CheckJobOperSeq
> String whereClause;
> JobEntry je = new JobEntry(((Session)oTrans.Session).ConnectionPool);
>
> whereClause = "JobHead.JobNum='000202'";
>
> //JobHeadListDataSet jeds = je.GetList("JobHead.CheckBox01 = false and
> JobHead.JobNum='000202'", 0, 0, out funBool);
> JobHeadListDataSet jeds = je.GetList(whereClause, 0, 0, out funBool);
>
> //For each of the results I want to add an Operation with Sequence 115 and
> OpCode "Daily"
> foreach (JobHeadListDataSet.JobHeadListRow r in jeds.JobHeadList)
> {
> //Get the Job Data Set
> JobEntryDataSet jods = je.GetByID(r.JobNum);
> //Get a New Operation
> je.GetNewJobOper(jods, r.JobNum, 0);
> je.CheckJobOperOprSeq(r.JobNum, 0, 300, out outMsg);
> //Add the sequence number to the operation
> jods.JobOper[jods.JobOper.Count - 1].OprSeq = 300;
> //Change the OpCode
> je.ChangeJobOperOpCode("FINAUD", out outMsg, jods);
> //Update the Job
> je.Update(jods);
> }
>
> EpiMessageBox.Show("Done!");
>
> }
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is
> privileged and confidential. It is intended only for the exclusive use of
> the addressee. If the reader of this message is not the intended recipient,
> or the employee or agent responsible for delivering it to the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. If you have received
> this communication in error, please notify us at 727-578-6280 and
> immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the
> International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of
> this material is restricted by the Arms Export Control Act (22 U.S.C. 2751
> et seq.) and may not be exported to foreign persons without prior approval
> form the U.S. Department of State."
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is
> privileged and confidential. It is intended only for the exclusive use of
> the addressee. If the reader of this message is not the intended recipient,
> or the employee or agent responsible for delivering it to the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. If you have received
> this communication in error, please notify us at 727-578-6280 and
> immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the
> International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of
> this material is restricted by the Arms Export Control Act (22 U.S.C. 2751
> et seq.) and may not be exported to foreign persons without prior approval
> form the U.S. Department of State."
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]