🚀 go-pugleaf

Mike McGlothlin wrote:
> 
> I have hundreds of reports created in crystal that use one of four var.
> (j1,j2,j3,j4) to select the records to print. I have converted all the
> reports to the new report styles and all my select criteria are out the
> windows but the col. and formula were translated. A SQL is also created
> that "select *". If I could pass a parameter to the where cause then I
> could have all my reports fix in no time The book(&help file) only
> reference to passing parameter is to "where fieldvar = :var1" no examples
> any where else. I can not get the SQL designer to except a parameter. 

Mike -- don't use the sql designer for this. 

Instead, try just using a straight query or data module. Then, check to
see the type of the memvar (to make sure it exists) in the onOpen for
the form or report:

   if type( 'var1' ) # "U" // not undefined
      form.queryname1.sql = "select * from tablename where "+;
                            "fieldname = '"+var1+"'"
   endif

(Note -- use the single quotes if this is either a date or a character
value)

Hope this helps a little.

Ken