November 27, 2001 at 11:29 am
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
November 27, 2001 at 12:06 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply