Steve, try using the modern syntax. SET VAR Vendorevalfnl INTEGER -- SET VAR Vendorevalcnt INTEGER -- Not needed SET VAR i1 INTEGER -- NULL indicator only SELECT (COUNT(POn) - 43839) INTO Vendorevalfnl i1 + FROM VendorEval
--- Steve Breen <[EMAIL PROTECTED]> wrote: > It's been along day and I just can't remember or get this. > > Any help would be appreciated > > > > Set var Vendorevalfnl int = 0 > > Compute Vendorevalcnt as Count POn from vendoreval > > show var Vendorevalcnt - this is for test purposes only > > set Vendorevalfnl int = (.Vendorevalcnt - 43839) > > show var Vendorevalfnl - this is for test purposes only > > > > Thanks > > > > Steve > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
