Question: I copied the following code from a good book on e-commerce, but the VB code (Visual Studio 6.0 Enterprise) gets an error on the Dim rsBankData line “User-defined type

Question: I have a barcode saved as a GIF that is truncated each time it is printed from Netscape. It prints fine in Internet Explorer and Netscape 4.04 but does

When multiple clients perform batch updates against the same database table, ADO by default raises a conflict when different users modify the same field: in other words, if two users

ADO includes the capability to work with disconnected Recordsets, which is a great way to save database connections. The typical sequence when working with such Recordsets is as follows: (1)

Under VB6 you can create new SQL Server and Oracle tables – but not MDB tables – without leaving the environment. You only have open the DataView window, right-click on

If you are familiar with the ADO capability to create stand-alone Recordsets from the thin air, that is by adding items to their Fields collection, you’re also probably aware that

‘ Check if a value is Null. If not it returns the value, ‘ otherwise it returns the ValIfNull argument, or zero/null string’ if the second argument is omitted” This

ADO lets you create a Recordset without creating an explicit Connection object, using the following syntax: Dim rs As New ADODB.Recordsetrs.Open “Authors”, “DSN=Pubs” If you later want to create another

Everyone tells you how to import, but even MS-VB techs start coughing when you ask how to export with DAO! In fact, their own documentation clearly states that it can

Using Java, you can easily find out what Web server is installed on a remote machine. Just open a URLConnection to the remote host and parse the header for the

There are a lot of graphics packages for Web pages on the market, but sometimes you still want a homegrown solution. Using just HTML, it is possible to create simple

SafeRef() returns a reference to the context wrapper instead of a reference to the object itself. You should never pass a direct reference of an MTS object to a client

Imagine you have to write a simple stock quote application that accepts stock symbols and retrieves their current values. Using a std::string object to represent a stock symbol is inefficient

When a program opens a file, the operating system returns a corresponding file descriptor that the program refers to in order to process the file. A file descriptor is a

The standard header contains forward-declarations of the I/O classes and templates. This header is sufficient to refer to any of the I/O classes and templates but not to apply operation

Overloading the function call operator can be somewhat confusing because the overloaded operator has two pairs of parentheses. It may not be immediately obvious which of these pairs declares the

The abbreviated forms “ctor” and “dtor” (“c-tor” and “d-tor”) are widely used in C++ literature, newsgroups, magazines, and in the ANSI/ISO Standard. These terms are simply the shorter forms of

How would you like to be able to make a form automatically resize and reposition all its controls and fonts whenever you resize the form? How would you like to

Here’s an easy method for making sure your users enter only numeric data, and only one decimal point. First, place two Public procedures in a standard module. You can use

When you’re editing a series of controls, you can multiselect them either by clicking while holding down the Control button or by “lassoing” them with the mouse, then enter the

Standard VB forms don’t support a scrollable client area. Normally, when one is needed, programmers resort to convoluted solutions such as filling the client area with a picture box, placing

Question: I have to make a programm to read DATA from a Card, the first function that I must call says: Function_name(hcaller As Long,…) This hcaller is an hWnd and

Question: I am designing a three tier architecture framework. For passing data from one tier to another, I am using ADO disconnected recordsets. For Reading, Updation and Deletion, I create

Question: What’s the consensus as to whether it is better to use the ADO native driver, or use the ADO ODBC wrapper with Oracle? Answer: Microsoft now provides a native

Question: I have used several ADO data controls as well as one data environment designer in my app. This appears to “hardcode” the path to my database forcing me to

Question: What is the correct format to create a SQL string using embedded variables? I keep getting a message that says I have an “incomplete query clause”. I am trying

Question: How do I get the TextBox to display automatically at the end of text instead of at the begining of the text? Answer: Set the SelStart property of the

Question: While using the dateadd() function to add the given number to an existing year, it adds the days instead of years if we use the command in the following