mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Form Validation
  • Validating via an SQL Procedure Source Code
Back to Manual

Validating via an SQL Procedure Source Code

 

create procedure mrcworklib.validdates
(inout i_error char(99),
 inout i_strdate decimal(8,0),
 inout i_enddate decimal(8,0))
LANGUAGE SQL
CASE
when i_strdate = 0 and i_enddate = 0 then
   set i_error = 'You have not entered any dates.';
when i_strdate = 0 then
   set i_error = 'You must enter a starting date.';
when i_enddate = 0 then
   set i_error = 'You must enter an ending date.';
when i_strdate > i_enddate then
   set i_error = 'Start date is later than end date.';
else
   set i_error = ' ';
END CASE

Created: February 10, 2010 | Modified: December 22, 2011

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

App Properties Retrievals Email Application Properties Popular DB2 Production Graphing Dates Maintainer Performance Prompt Screens Dropdowns Excel Administration Freemarker Getting Started SQL Reports Advanced Maintainers Video Record Selections Report Graphs m-Painter Java Bootstrap Templates Data Dictionary mrc-Productivity Series Retrieval Parameters Summaries Bar Graphs Database Admin Calculations External Objects Tomcat Security RPG Build Process Graph Properties Form Validation Compiling

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Policy Cookie Policy Notice at Collection California Consumer Privacy Act (CCPA) Opt-Out IconYour Privacy Choices
mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2023 mrc. All rights reserved.