Search results for query: *

My company has just upgraded to v2r5 and a user has hit a snag with a query they're running which has the following line of sql count(sum(PRD_BO_CCM_VIEWS.ROCK_EVT_AGNT_ACTVY.DGT_DIAL)) Teradata flags this as an error as it logically cannot nest aggregate functions. However, if Teradata could...

Hi, Hope someone can help me. I'm getting a 3265 error message and when I execute my program VB6 stops on the "Set COL = TBL.Columns(FLD.Name)" line. All I want to do is copy a table format from one dAccess db to a new Access db that my program creates. Any thoughts? I've tried a...

Provided you have a central repository set up holding universes, delete the local copy of the file from your computer and restart BO. This will force BO to download a new copy from the repository.

johnwm, that was a quick response!!! In answer to your question Head() is a 1 based array and I've used it elsewhere in my program to populate a flexgrid. The values contained within the array are currently "Column 1" through to "Column 5" and null strings are not passed...

Hi, Hope someone can help me. I'm trying to create an Access Db with VB6. Creating the Db isn't a problem and neither is creating a table or inserting data into the table when I explicitly declare the column definition like this: tbl.Columns.Append "Column 1", adVarWChar, 40...

Thanks for the responses so far. The database is NCR Teradata and the version of BO I've been using is 5.13, but the problem also occurs in 5.02 and 5.15. In response to Steve's question: The report will complete if I run it without the time limit but it is still significantly slower compared...

Hi, Hope someone can come up with an answer to this problem. I'm running a report in BO which times out. The universe limits are 10 minutes and 50,000 rows and the report has two prompts, one for "begin week" and the other, "end week". When I copy the SQL and paste it into...