Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Code Translation

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Good evening dear gurus!
I have a need for code translation and I am hoping that someone here has some oracle knowledge as well as informix.
Below is an informx code and I have spent 3 days trying to understand it and change it to oracle without success.
I will really appreciate it if someone can help me.
I am just new to informix and I need to understand it in order to translate to oracle.
Here is the informix code:

before editupdate of task1 (this is table_name)
nextfield=v

after editadd editupdate of first_task (this is a field in above table_name called task1)
let dpa=dp1
let c1=ca

before editadd of call_reqd second_task (another field name in table task1)
if ( calr="00" or calr="A0" )
then
begin
comments
" Must complete corresponding county codes"
end

after editadd editupdate of second_task(same field name in table task1 as above)
let dpb=dp2
let c2=cb

after editadd editupdate of third_task(another field name in task1 table)
let dpc=dp3
let c3=cc

after editadd editupdate of fourth_task (another field name in task1 table)
if ( k="B" )
then
begin
if ( j=" " )
then
begin
nextfield = j
comments bell
" REFERRAL MUST HAVE AN ENTRY"
end
else
nextfield = l
end
)
My biggest questions are:
How do I translate before editadd and after editadd?
also how do I translate nextfield = some value?
thanking you in advance.
jenny01
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top