| Creating Procedure (2 merged) [message #683040] |
Sun, 29 November 2020 03:05  |
shahzaib_4vip@hotmail.com
Messages: 406
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  |
 |
Michel Cadot
Messages: 68418
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.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
