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!

Search results for query: *

  • Users: Pinan
  • Content: Threads
  • Order by date
  1. Pinan

    TDQM Scheduling query length issue

    We are trying to use TDQM to allow users to schedule jobs to run at off peak times. The issue is, that the queries that we want to do this with are huge.. like 60,000 characters long (a little more than 11 typed pages). Big, nasty, data mining types. However, only the first 30,000 charachters...
  2. Pinan

    certification study guides

    Does anyone have any recommendations for study guides for the Teradata Certification tests?
  3. Pinan

    reset the timeout

    I am querying a large amount of data, and periodically, it does not return before it gets timed out. How do I set the time before timeout longer?
  4. Pinan

    query definition cashe size

    I have an connection string sending information to a database, and it works fine, until the information quantity exceeds the cache size for the connection string. this is the code that inserts the information. 'define the worskpace and connection Dim wrkSpace As Workspace Dim...
  5. Pinan

    Making color gradient

    I am trying to get background color to fade. Such as a dark blue on the lower left corner, fading over to a light blue on the upper right right. Anybody done this before?
  6. Pinan

    cube root (higher math)

    Does VB have a function to handle cube roots? Seems odd that I can find where to calculate the inverse hyperbolic cotangent, but not cube root...
  7. Pinan

    Populating a listview from an array

    Alright, I am working with a listview, and it works fine. But it only displays the first 2 lines of info from the array (which is getting its info from a db table. so it could have 1 line of info, or a hundred. Maybe even more). So I know its gotta go to a loop, but there are some problems in...
  8. Pinan

    odbc database to visual basic to excel

    I have an application wich is pulling information from a odbc database (teradata), and sending the output to a textbox. However, I dont like the format, so I would like to send it to an excel spreadsheet which would be contained within some sort of window (textbox, labelbox, whatever). The...
  9. Pinan

    Sending information to a ODBC database

    This is the code that I was given to retrieve information from a database. EDWInfo.Open strPullSQL, Cnxn, adOpenForwardOnly, adLockReadOnly, adCmdText lblBigOut.Caption = "" Do Until EDWInfo.EOF Do Until EDWInfo.EOF lblBigOut.Caption =...
  10. Pinan

    vb/sql communication problem

    I have a vb/sql quesry that sort of works, and I cant tell where the error is. Here is the code. strPullSQL = "SELECT * from bw5833.test_table WHERE (username LIKE '%" & txtSearch & "%') AND (Date_Run LIKE '%" & txtDate & "%') AND (PI_Value LIKE '%" & txtPI.Text &...

Part and Inventory Search

Back
Top