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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jakeH
  • Order by date
  1. jakeH

    Teradata SQL and Nested Functions

    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...
  2. jakeH

    A '3265' Error Message

    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...
  3. jakeH

    Unhandled exception

    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.
  4. jakeH

    Creating an Access Table Problem

    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...
  5. jakeH

    Creating an Access Table Problem

    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...
  6. jakeH

    Business Objects Performance

    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...
  7. jakeH

    Business Objects Performance

    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...

Part and Inventory Search

Back
Top