Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mpcohen
-
Date Based Query off the Max of the Date
This looks like a SQL Server question rather than a BRIO question. You can include the max date in a sub-query. You would write: select Sum(Daily.Amount) AS SumOfAmount from Daily where Daily.Date >= (select DateAdd("m",-3, max(Daily.Date)) from Daily)- mpcohen
- Post #2
- Forum: Data Management Tools general discussion
-
Optimizing brio query with Oracle 8.1.6
This is a problem that I have also run into. One thing that you can try is to create a view in Oracle with the desired query and then just reference the view in BRIO. Sometimes this works. If this does not work, another approach is to have a stored procedure insert data into some other table...- mpcohen
- Post #2
- Forum: Data Management Tools general discussion
-
Problems with EIS development
Without seeing your code it is a little difficult to answer your question. If you want you can send me an email at mpcohen@mindspring.com. Some general pointers. Use Active Document.Sections to reference limits, methods and controls. Everything is case sensitive and it is easy to make...- mpcohen
- Post #2
- Forum: Data Management Tools general discussion
-
ActiveDocument.Sections Where is Process ?
YOu should have a section with the name of the query. If you did not rename the query section it will have the default name of QUERY. Open that section and find process among its methods.- mpcohen
- Post #2
- Forum: Data Management Tools general discussion
