RE: [sqr-users] SQR logic in SQL

["Knapp, Richard" <KnappR@umsystem.edu>]

Putting SQR logic around the SQL is what SQR does.  Some examples would
make this clear.  Do you have any documentation?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
DICKMAN, ERIC C.
Sent: Monday, June 28, 2004 10:29 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR logic in SQL

> Hello Everyone,
> 
> I am fairly new to the programming language of SQR.  I am attempting
to
> dynamically populate some SQL values in SQR and when the value does
not
> exist it creates problems the SQL (returns nothing).  Is it possible
to
> put SQR logic around the SQL. I created an example below of SQR logic
in
> SQL Is it possible to do something like that or is there another was
to
> handle this problem in the SQR?  The CARYEAR value is '' (no parameter
> entered by the user) many times, because the values in passed in from
a
> Search page. 
> 
> I pass in the follow variables:
> CARTYPE = ('Mustang','Corvette','Accord','Ranger')
> CARYEAR = ('')
> 
> ask {CARTYPE}
> ask {CARYEAR}
> 
> move  '{CARTYPE}'                 to $input_car_type
> move  '{CARYEAR}'                 to #input_car_year 
> 
> SELECT * 
> FROM  CAR  C,
>       YEAR Y,
> WHERE       C.FAST > 150
> AND         C.TYPE IN ([$input_car_type])
> 
> if $input_car_year  <> '' 
>  AND         Y.YEAR IN ([#input_car_year])
> end-if
> 
Thanks,

Eric 


NOTE: The Texas Department of Protective and Regulatory Services (TDPRS)
has
changed its name to the Department of Family and Protective
Services(DFPS)
resulting in the following e-mail address format change for all
employees:
firstname.lastname@dfps.state.tx.us 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users