Search results for query: *

I am looking for a method to create and deploy generic, reusable functions on multiple databases across multiple SQL servers. For example, what I would like to do is to provide a wrapper for the scripts I have for doing things such as searching for a given text string within all stored...

i'm looking at a stored procedure that uses temp tables in an UPDATE...SET...FROM...WHERE stmt- i've never seen this combination before. i will note that in the example below, a column was created (AREA_1) with a very similar name as the temp table (#AREA_1) UPDATE #TempCurCred SET...

i have created an xml schema and am trying to ensure the syntax is correct. i am using the on-line validator from the w3c site... http://www.w3.org/2001/03/webdata/xsv. the schema can be found at the location... http://cougar.freewebpages.org/SNACSClaim when i try to validate the schema using...

is there a way to programmatically full expand a drill down report? i have a report that i would like to present the user with an option to print the full report or drill down to the desired level & print.

i have a report with the following 4 fields as illustrated below... district members days average ====== ====== === ===== Northeast 10,000 10 1,000 Southeast 20,000 10 2,000 i have set up the report for grouping by district and members is a summary field that is...

i have a client who tries to execute the following code which displays data in an excel workbook within the browser. however, the result of executing this code is 'unable to initialize visual basic environment". i am unable to duplicate this problem locally on my box. could this prob be...

when attempting to perform a 'get latest' from the project explorer, the following error is received... Failed to reload the project. fyi... i am running VS-SP5 on Win2000

i have an interdev solution that contains approx 20 asp files on the project level and an additional 6 asp files under an include folder. when i run the application within interdev, i can see the changes that i make on the asp files on the project level, but the changes to files under the...

I am trying to update all rows in a table based upon values found in another table. Below is an example of what I am trying to accomplish... UPDATE table1 t1 SET t1.column1 = SUM( SELECT t2.column1 FROM table2 t2 WHERE t1.column2 = t2.column2 AND t1.column3 = t2.column3 AND...

Does anyone know if there is a freely available ODBC or OLEDB driver for accessing a DB2 database on an OS/390 mainframe? Would this be included in a version of MDAC? I found an article referencing this in the MSDN Library that mentioned a freely downloadable driver from Neon systems and it is...

I am trying to select values from one table which meet the criteria of a range of values found in another table. Perhaps displaying the SQL would provide a better illustration... Below is the SQL statement that I currently have that returns an error: "Subquery returned more than 1 value...

Is there a way to programatically empty the recyle bin?

What is the best way to check to see if a file is being accessed by another process? Specifically, if the file is being written, I want to restrict access in a For Each loop when using the FileSystemObject in the Scripting library. For example, I am looking for the code required in the...

Using the code below, I am able to send ONE email successfully. The next time I run the app with the same username & password, I receive RTE 32002: Login has failed. I have Novel Groupwise 5.5 installed locally... Private Sub Main() ' Error Handling On Error GoTo ErrorHandler ' Body...

Using the DataGrid Active-X Control Version 6(sp4) to bind to a recordset object, I am having the following difficulties... 1- Editing and making a change to the grid does not update the associated database table (SQL Server). I thought that if the grid was bound to the recordset, that any...

I am using wininet.dll in VB6 to develop FTP functionality. I am trying to use the FTPCommand function to send the following command when connected to a mainframe FTP server: "quote site lrecl=127". I can connect to the mainframe and execute this command successfully using...

I have a table which I cannot import data into. This table contains a column of type 'timestamp'- which may or may not be the culprit. I can even export the data from this table to a comma-delimited flat file, delete the rows from the table and then try to import them back into the same table...

I want to transmit files via FTP to a mainframe location using the API functions within WinINet.dll. I see that in unix, to FTP to a mainframe location, a "quote site" command must be issued to set properties such as record length, block size, etc. prior to calling the put or mput...

I want to transmit files via FTP to a mainframe location using the API functions within WinINet.dll. I see that in unix, to FTP to a mainframe location, a "quote site" command must be issued to set properties such as record length, block size, etc. prior to calling the put or mput...

I am trying to use the WinINet.dll API functions to retrieve all of the filenames in a designated FTP directory by using the following generalized snippet of code... hFind = FtpFindFirstFile(hConn, &quot;*.*&quot;, pData, 0, 0) While hFind <> 0 Call colFiles.Add(pData.cFileName)...