Re: sql -457 error

Bob Baskett writes: >can anyone tell me why the following sql dies with a -457 error: > > select > tech_group, > sum(net_book_units), > sum(net_book_dollars), > sum(net_bill_units), > sum(net_bill_dollars ) > from book_bill_back > where book_bill_back.rowid = -1 > and fiscal_date >= TODAY - 90 > group by tech_group; > >but if i modify it to the following it works fine: > > select > tech_group, > sum(net_book_units), > sum(net_book_dollars), > sum(net_bill_units), > sum(net_bill_dollars ) > from book_bill_back > where book_bill_back.rowid = -1 > { and fiscal_date >= TODAY - 90 } > group by tech_group; I shouldn't think either one would work, as you cannot have a negative rowid. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney