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...
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...
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?
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...
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...
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 =...
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 &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.