Skip to Content mrc logo mrc logo
  • 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
  • What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management 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 & Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Development Services Training Mentoring
  • Overview Partners Press Releases Careers Events Contact Blog
  • 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

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

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

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


© mrc. All rights reserved.