On Jan 9, 2007, at 9:19 AM, johnf wrote:
> Also I'm not to sure normal users have access to the
> "information_schema". I
> only know that access is assumed OK on public "sysobjects tables".
Even if they have complete unfettered access to information_schema,
what good would it do for this query?
select sum(orderitems.amount) as totalsales, ...
Where will information_schema have anything about the 'totalsales'
column in your cursor?
Use the dbapi, Luke!
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
