|
-
Help please!!!
To all you SQL Guru's out there......I bow down to you!!
I was wondering if I may pick ur brains for a moment or two.....
Basically, I need to insert the following code into a Button on a Form. The code works perfectly in SQL + but i am unsure as how to adapt it into the button, as the Procedure needs to get the data from fields on the form, as opposed to me entering the data wen executing it from SQL +..........
Create or Replace procedure insert_promoinfo (WrkFrc_ID varchar2, NGrade varchar2)
As
WF_ID varchar2(5);
OldGrade varchar2(2);
AdvancementDate date;
begin
Select WORKFORCE_ID, Grade INTO WF_ID, OldGrade FROM Workforces
WHERE WORKFORCE_ID LIKE WrkFrc_ID;
AdvancementDate := Sysdate;
Insert into Advancements values (AdvancementDate,NGrade,'',OldGrade,WF_ID);
END;
Would it be possible for someone to ammend the code and post it back??
The forms fields are 'WORKFORCE_ID' and 'GRADE'. The name of the form is WORKFORCE_DETAILS.fmb with my user area being called 'RA912'.
Please please please could someone help me here.....my friends and I have been pouring hours into this, and everything fails.......
Thanks for ur time,
Regards....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|