Creating Procedure (2 merged) [message #683040] |
Sun, 29 November 2020 03:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Dear All,
Good Day!
My table is
Sale_Date , Chassis_number , Customer_name , Sale_price, Initial_advace, Rcd_from_customer
I create a report which show's detail balance of customer coming like
05-11-2020 , AZE15400120060 , CS Motors , 5000 , 500 , 3000 , Balance = 1500
05-11-2020 , AZE15400162060 , CS Motors , 7000 , 1000 , 3000 , Balance = 3000
05-11-2020 , AZE15400182060 , CS Motors , 6000 , 1000 , 5000 , Balance = 0
My report is working fine
Now I want Customer Limit if balance amount increased from 4000 then Entry permit will not allowed so I need to create some procedure which will call in form when I click on submit button to entry a new record.
Sorry for my bad English
|
|
|
Re: Creating Procedure (2 merged) [message #683042 is a reply to message #683040] |
Sun, 29 November 2020 04:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
|
|
|