Search results for query: *

Our BCS was installed in 2000, and has no LAN functionality (i.e. C-LAN etc...). We have the typical 100+ digital ports (sets are 6402D), and 16 analog ports for modems/fax/etc. We just came across the need to extend a 6402 across the LAN. This location is connected via a wireless link with no...

I wish to write a 'virtual tapedrive' for use on my Linux system (gcc 3.2.2). The code will be your basic I/O filter (with enhancements of course). If I call it 'vtape', here is how I imagine using it: Backup: tar -c /home | vtape Restore: vtape | tar -x Within vtape.c, can I tell which...

I would like to dual boot an XP system so that the HD is partitioned in two, and each partition is a completely independent WinXP install. Is it possible so that when the second partition is booted, it shows up as C: (in the old days, the drive letters were assigned to partitions in their...

I am designing a VB6 app, and the type of control that would be perfect is the Tasks view from Outlook 2000. It's kind of like a grid with several rows/columns. The sort order can be changed to any of the columns. Here's the part I need: Multiple rows can be Grouped By some criteria. Then...

My table is many rows, by 2 columns. I want a border around each row. Put another way, I want borders everywhere except between the 2 columns. My trolling has only found one solution: for each <TD> in col #1, define top, left, and bottom borders. Then for each <TD> in col #2, define top...

Here's the SQL (Oracle): select a.name, b.amount from users a, quota b where a.name = b.name(+) order by a.name; The problem is the rows returned that don't have a corresponding record in the quota table. The amount field is displayed as blank/null, but I need it to display as a 0. Is this...

I'm creating a small utility for custom SQL table synchronization. I need to store the binary value of a timestamp field into a status table. In this status table, I can't use the actual timestamp type since SQL will then automatically update it -which I don't want. However, in my source...

I've got a short delay at the end of my Form_Unload routine to ensure the status box says on the screen for a few seconds. While in this routine, I would like to 'detect' if the user presses the [X] "close window" control button so I can expedite the delay. Could this be possible?

Hello, I have one location in my code where I want custom error trapping. After that, I wish the (non-)error handling of VB to return to normal. In other words, can I reverse the effects of my one and only ON ERROR GOTO statement? -thanks note: I know about disabling error trapping (ON ERROR...

My VB code is choking on the 8-byte SQL type 'timestamp'. I'm getting a Type Mismatch error. I know that this SQL value is note really a date/time, but rather a binary value. I'm trying to load a timestamp value (via ADO) into a Date variable (also 8 bytes) -Choke. I've also tried a variable...

I need to add an auto-updating timestamp column to a vendor-supplied table. Unfortunately, the vendor already has used the [timestamp] name for a custom-column (using the datetime type). If I create a column with a different name, but still use the timestamp type, will SQL still auto-update...

I have an ADO recordset: rs.source = "select * from myTable where myField = 'X'" rs.open I wish to delete ALL the records in this record set. I know I could loop through all them, but I'd rather do it in one fell swoop. I have an ADO book that mentions using the adAffectAll parameter to the...

I know the SYSOBJECTS table has a CRDATE field for the table creation date. Is there a built-in way to tell when a table was last updated? (by built-in, I mean without triggers and code). -thanks

I've written a VB6 app that makes a DSN-less connection to a SQL2000 DB. After much experimenting, I've got things to work with both ODBC and OLE methods (see below). Presently, the database is small but I would like to maximize efficiently for when it is huge. Is one of these methods a...

Our ERP system runs on a SQL2000 backend. Our LAN is Novell Netware. It appears that we need our workstations to issue a "NET USE \\ERPSERV\AITERP guest" command before the ERP client can connect to the SQL server. What gives? Why does the workstation need to establish an underlying...

I've seen many different ways to 'connect' to a SQL database. I'm using ADO and I need the 'best' DSN-less way. One site recommends the following: With cn .ConnectionString = "Driver={SQL Server};" & _ "Server=(erpserv);" & _ "Database=" & sDB...

I need my VB app to iterate through the items in the Outlook/2000 Contact folder, and save these items to a SQL database (via ADO). These records will be read back later and re-inserted into a different Contacts folder. My idea is to save the entire Contact item in one go (instead of field by...

My app needs to know when the currently running Outlook 2000 process has added/changed a record within the Contacts folder (in the local .PST). I found a snippit of code earlier that detects the ItemSend event of the Outlook.Application object -works great. There are only a few other events of...

My app (VB6) dynamically builds a report in Excel. One of the requirements is setting the viewing zoom to 75%. There appears to be a .Zoom property of the ActiveSheet, but it errors out when assigning 75 to it. My research so far has only turned up examples of the .PageSetup.Zoom property...

The following command: SELECT gltype FROM glacnt30; works great. The following command: SELECT gltype FROM glacnt30 GROUP BY gltype; bombs with the following error Command contains unrecognized phrase/keyword. I'm using VFP6 SP5, and entering the SELECT commands directly in the Command...