Search results for query: *

I'm a VB6 developer, and I'm trying to learn VB.NET (perhaps not the best way) by converting some code from VB6. I'm having trouble finding the equivalent for the VB6 Array() command. This is my VB6 code: function call: Set rst = ADO_RunSPReturnRSParm ( _ strDBConnect, "sel_facts"...

(Oracle 8.1.7) Is there any performance difference between the following two code examples? Are they both actually binding the my_sal variable? Apart from performance, is there any reason to choose one method over the other? -- Option #1 DECLARE TYPE EmpCurTyp IS REF CURSOR; -- define...

I've just finished writing a routine to search for a row in my listview based on the character that the user types over the given column. I identify the column the mouse is over (MouseMove) and trap the character typed in (KeyPress) and then search the subitem (corresponding to the column the...

Windows 2000 Workstation client, Windows 2000 Advanced Server. SP4 on both. I'm trying to get a logoff script to work, but in certain cases it's not being executed when I log off. It's a simple 1 line IF EXIST C:\XYZ DEL /Q C:\XYZ\*.* and it works when executed manually, but not when I create...

Windows 2000/ Oracle 8.1.6 I'm trying to load a tab-delimited file into a table, but when it encounters a record with an empty column, it seems to ignore it and errors out on "Record 19: Rejected - Error on table SRADB.SAP_EXTRACT, column REVISION_CODE. Field in data file exceeds maximum...

I'm not sure this is the right forum for this, since it's more of an ADO question. I have an ActiveX Script Task that reads an Excel workbook and processes its worksheets with an ADO recordset. I process the worksheet column names (first row of worksheet) as recordset fields, but some field...

CF v5, Excel 2000. I'm generating Excel output using the Internet Explorer Excel add-in. I create an HTML table and use the <CFCONTENT TYPE=&quot;application/vnd.ms-excel&quot;> tag. My output is mainly text, retrieved from SQL Server, with embedded carriage returns+line feeds (ascii 13+10)...

I am running Back Up Exec 8.6 rev. 3808 on a Windows 2000 Server with SP3, dual 400Mhz processors and 512Mb RAM. Occasionally when I reboot the machine, the Backup Exec 8.x Job Engine service hangs and will not allow the program to connect to the server. Rebooting again seems to solve the...

Is it possible to send e-mail from the Task Scheduler? I would like to send an e-mail notification when a task does not complete successfully (i.e., return code not = 0). If it isn't possible directly from the Task Scheduler, is there a way to send e-mail from a batch script (DOS command or...

I'm trying to create a logoff script to deletes any files left in a particular folder. I need to create it for 2 specific Win2K workstations in our domain. I've tried doing the following from the domain server and from one of the workstations, but neither method succeeds in getting the script...

I'm trying to use Package & Deployment Wizard (PDW) to update my client PCs with the latest version of my VB application. I'm using VB 6.0 (SP5) on Windows 2000 clients. Recently, I noticed that there are &quot;mutliple&quot; versions of the installation in &quot;Control...

Oracle 8.1.6 Enterprise Edition on Windows 2000. I'm getting a PLS-00201 error due to no privileges granted on a procedure, but I would like to translate for a user interface, or generate an Oracle error that says that there are no privileges on the object. User 1 has been granted Role A...

I would like to pass on Oracle messages to users telling them that they don't have privileges to execute a procedure, but the messages seem very cryptic for users: &quot;PLS-00201: identifier 'schema_name.procedure_name' must be declared&quot;. Isn't it possible to get a more descriptive...

I would like to pass on Oracle messages to users telling them that they don't have privileges to execute a procedure, but the messages seem very cryptic for users: &quot;PLS-00201: identifier 'schema_name.procedure_name' must be declared&quot;. Isn't it possible to get a more descriptive...

I have a Visual Basic 6.0 app. running under Citrix Metaframe 1.8 on Windows 2000 Server, with Office 2000 Premium installed. I'm getting a &quot;Windows Installer&quot; message each time one of my users runs the VB app. The VB app. runs OK otheriwse; it's just annoying to see this message. I...

Here is an &quot;Out of memory&quot; error message that seemingly has nothing to do with memory. I have a line of code which references a DataCombo's BoundText in an If statement: &quot;If strSaveCountryCode <> dbcCountryName.BoundText Then ...&quot; If this code is executed after clicking on...

VB 6.0; ADO 2.6. I have a DataCombo control bound to an Adodc. I programmatically create a recordset from a stored procedure, and assign the recordset to the adodc: Set Adodc.Recordset = rst. Then I set the rst to nothing. I would then like to sort the DataCombo's data with the recordset...

My application is VB 6.0 using ADO v2.6 against Oracle v8.1.6 with the MS OLE DB provider for Oracle. I've built a data-access layer in a DLL for my ADO code, and I use the same classes in this DLL for other VB applications that use MS SQL Server. In my ADO code, I only use stored procedures...

My application is VB 6.0 using ADO v2.6 against Oracle v8.1.6 with the MS OLE DB provider for Oracle. I've built a data-access layer in a DLL for my ADO code, and I use the same classes in this DLL for other VB applications that use MS SQL Server. In my ADO code, I only use stored procedures...

I'm looking for a simpler way of selecting a row whose child rows match all values in a comma-delimited list. I'm using SQL Server v7.0 with stored procs. and dynamic SQL (EXEC @sql_string). I pass the string parm. (e.g., 'Bob Smith','Mary White') and expect it to only find a parent rows that...