Select * from inventory

where ({?mycategory} = 'Complete List')

  or ({category} = {?mycategory}

 

-Dell

 

-Dell

table linking is like...from emp to jobs

 

then using enforce from..v can select only 'to table' fields rite ...

 

but im not getting the values....

 

using enforce to

(select empname from employees where emp.jobid=jobs.jobid )

 

using enforce from

(select jobdesc from jobs where emp.jobid=jobs.jobid)

 

is this two queries rite..??...

but for me...oly if i select fields from to table i.e; jobs table den oly its displaying values...or else nothing is being displayed

 

so plz help me out....

 

 

 

IF '{?mycategory}' = "Complete List"

  BEGIN

    SELECT * FROM inventory

  END

ELSE

  BEGIN

    SELECT * FROM inventory WHERE category = '{myCategroy}'

  END

 

 

This will work as a CR Database Command object since it is all SQL. Also, if you are allowing custom values for the {?mycategory} parameter, you may also want to do the following check on it before running the query:

 

IF '{?mycategory}' != ''

  BEGIN

    -- Do some stuff.

  END

 

Note that I checked for the empty string. Parameters are always converted to a string type when replaced into the SQL command (at least, that's been my experience...but I could be wrong on that). So you should not use this code, as it will never be true:

 

IF {?mycategory} IS NULL

  BEGIN

    -- Do some stuff

  END

 

HTH.