How to insert a record by 4GL in OpenEdge Database

Yahoo Archive
1
FIND FIRST company.
FOR EACH tt-part WHERE tt-part.partnum <> "".
FIND FIRST part WHERE part.company = company.company
AND part.partnum = tt-part.partnum
NO-ERROR.

IF NOT AVAILABLE part THEN
DO:
CREATE part.
ASSIGN part.partnum = tt-part.partnum
part.company = company.company.
END.
ASSIGN part.partdesc = tt-part.partdesc.



Babette Welch
IT Director
bwelch@...
(906)226-9747 ext: 235
ARGONICS, INC.
Performance Polyurethanes

________________________________________________________________________
3a. Re: How to insert a record by 4GL in OpenEdge Database.
Posted by: "mintokmint" mintokmint@... mintokmint
Date: Tue Jul 8, 2008 6:22 pm ((PDT))

I just want to know the Phrase.
Many thanks




[Non-text portions of this message have been removed]
2
Insert into Customer (CustID,CustName) values(123,'GE Company')
how can do in with 4GL phrase?
and how can update ,or delete a record?
3
> Insert into Customer (CustID,CustName) values(123,'GE Company')
> how can do in with 4GL phrase?
> and how can update ,or delete a record?

First, I would NEVER recommend going into the Vantage database directly and
making changes. You can easily corrupt your database and invalidate your
support agreement. You're better off using the WebService or Business Object
interfaces which enforce Vantage Business Rules/Logic.

Having said that, the OpenEdge 4GL reference is located here:
http://www.progress.com/progress/products/documentation/docs/dvref/dvref.pdf

Mark W.
4
Mark...and others who know....
WebService and Business Object are new "terms" to me for writing to the DB. I had been focusing on Service Connect as a means for importing some of our data into a new 8.03.4xx database (or maybe even 9.xx). Because we plan a wholesale re-write of our Chart of Accounts we are planning to re-implement rather than convert existing data but still want to be able to bring in the BoM and MoM info for parts as well as customer info. Later on we would like to use the same method on-going for importing quote info (and asociated BoM/MoM for new parts from our external quoting system.

Is Service Connect still the route I should be investigating or is there something better? I plan to spend a fair amount of time at Perspectives on this subject so targeting a specific product would help a lot.

Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Tuesday, July 08, 2008 8:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to insert a record by 4GL in OpenEdge Database.


> Insert into Customer (CustID,CustName) values(123,'GE Company')
> how can do in with 4GL phrase?
> and how can update ,or delete a record?

First, I would NEVER recommend going into the Vantage database directly and
making changes. You can easily corrupt your database and invalidate your
support agreement. You're better off using the WebService or Business Object
interfaces which enforce Vantage Business Rules/Logic.

Having said that, the OpenEdge 4GL reference is located here:
http://www.progress.com/progress/products/documentation/docs/dvref/dvref.pdf

Mark W.





[Non-text portions of this message have been removed]
5
I just want to know the Phrase.
Many thanks