You need to be licensed in Open Edge to be able to write to the db.
Run the 'Config' applet on the Open Edge programs menu and look for 4GL Development System.
If you have that then you would:
for each ttporel.
create COMxref.
assign COMxref.company = "Your Company"
COMxref.file = "PORel_Mapping"
COMxref.Key1 = string(ttporel.PONum)
COMxref.Key2 = string(ttporel.POLine)
COMxref.Key3 = string(ttporel.PORelNum)
COMxref.foreignKey1 = "No"
COMxref.foreignKey2 = "Yes".
end.
Run the 'Config' applet on the Open Edge programs menu and look for 4GL Development System.
If you have that then you would:
for each ttporel.
create COMxref.
assign COMxref.company = "Your Company"
COMxref.file = "PORel_Mapping"
COMxref.Key1 = string(ttporel.PONum)
COMxref.Key2 = string(ttporel.POLine)
COMxref.Key3 = string(ttporel.PORelNum)
COMxref.foreignKey1 = "No"
COMxref.foreignKey2 = "Yes".
end.
--- In vantage@yahoogroups.com, Troy Richman <troyr@...> wrote:
>
> How would I insert a new record into the ComXRef table if one didn't already exist for the PO being confirmed?
>
> Thanks,
>
> Troy
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bw2868bond
> Sent: November-13-09 1:07 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM to Flag LockDate and LockQty on PO Releases
>
>
>
> Data is stored in ComXRef table
>
> COMxref.company = "Your Company"
> COMxref.file = "PORel_Mapping"
> COMxref.Key1 = string(ttporel.PONum)
> COMxref.Key2 = string(ttporel.POLine)
> COMxref.Key3 = string(ttporel.PORelNum)
> COMxref.foreignKey1 = "No" (lock date field)
> COMxref.foreignKey2 = "Yes" (lock qty field).
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Troy Richman <troyr@<mailto:troyr@>> wrote:
> >
> > Brian,
> >
> > I had already checked the PORel.LockRel field but it doesn't seem to change when the checkboxes are checked or un-checked.
> >
> > Troy
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Brian W. Spolarich
> > Sent: November-13-09 11:54 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] BPM to Flag LockDate and LockQty on PO Releases
> >
> >
> >
> > PORel.LockRel?
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> > bspolarich@<mailto:bspolarich%40advancedphotonix.com<mailto:bspolarich@%3cmailto:bspolarich%40advancedphotonix.com>> ~ 734-864-5618 ~ www.advancedphotonix.com<http://www.advancedphotonix.com>
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of robertb_versa@<mailto:robertb_versa%40yahoo.com<mailto:robertb_versa@%3cmailto:robertb_versa%40yahoo.com>>
> > Sent: Friday, November 13, 2009 2:46 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] BPM to Flag LockDate and LockQty on PO Releases
> >
> > Xref table
> > Rob Brown
> >
> > --- Original Message ---
> > From:"Troy" <troyr@<mailto:troyr%40wesgar.com<mailto:troyr@%3cmailto:troyr%40wesgar.com>>>
> > Sent:Fri 11/13/09 2:42 pm
> > To:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subj:[Vantage] BPM to Flag LockDate and LockQty on PO Releases
> >
> > I am trying to write a BPM to set the PO release LockDate and LockQty checkboxes to true once the PO has been confirmed. We want to stop PO suggestions from suggesting changes to PO's once they have been confirmed. However I have been unable to locate what table these checkboxes are attached to.
> >
> > Does anyone know where I can set these values?
> >
> > Thanks,
> >
> > Troy
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/><http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>