Global Variables

• Steve Johnson

  Default port

  Points: 1404

  More actions

  November 27, 2001 at 11:29 am

  #104598

  I am having problems assigning global var, if I write a simple query such as:

  "

  select getdate()

  "

  and set it to an output parameter assign the output to a global var it works fine but if I use a little more complex query such as:

  "

  select sum(idh_hist.idh_qty_inv * idh_hist.idh_list_pr) as Inv

  FROM ih_hist join idh_hist on (ih_inv_nbr = idh_inv_nbr),cm_mstr WHERE (ih_inv_date >= convert(varchar(15),getdate() - 1,110)) and(ih_cust = cm_addr) and not (idh_part like 'fr%') and not (cm_site like 'rd%')

  "

  No go, any idea's???

  Steve Johnson

  
  Steve Johnson

• Steve Johnson

  Default port

  Points: 1404

  More actions

  November 27, 2001 at 12:06 pm

  #420436

  Never mind.... I went into the query builder it validated the query and it works now????? don't really know why but it does.....

  Steve Johnson

  
  Steve Johnson