> > On Feb 14, 2008, at 1:00 PM, Jeff Boes wrote: > >> Specifically, I want to set: >> >> UI_DATE_BEGIN >> >> to the first year represented by transactions.order_date, e.g., >> >> select min(to_date(order_date,'YYYY')) from transactions; >> >> The only approach I've thought up (which I haven't tried yet) would be >> to define a module with a BEGIN block[1], and "Require" it in the >> interchange.cfg or catalog.cfg. Are there other approaches? I've determined this won't work, because the database connection isn't established at the time I need it to be in order to run the query. I really have to do this inside the catalog.cfg somehow, and after the point where the Database directives have been processed. -- Jeffery Boes <>< suppressed _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.