Question: I created an ASP that uses VB script to access an Access 97 database in a test environment. Here is the query used: “select * FROM property WHERE user

In a high-volume application, there’s a good chance that two separate transactions will both run the SELECT statement and acquire read locks before either can acquire the write lock required

Question: I have a mailing list with one record per person, but I want to mail to only one person per household. How can I select just the first record

Question: What is RDBMS? Answer: It’s lingo for “Relational Data Base Management System.” Related Posts Quick Way to Disable Copy-Paste in a Textbox in a WinForms ApplicationJudge Blocks Treasury’s Shareholder

Question: Do you know any good Web sites or have any tech tips on creating wizard interfaces? Answer: Creating wizard interfaces is straight-forward when you know how. All a wizard

Question: I have a difficult time using PB because I can’t see the code flow. I am an experienced programmer with COBOL, PL/1, and SQL and have taken several PB

Private Type POINTAPI x As Long y As LongEnd TypePrivate Type MSGTYPE hWnd As Long message As Long wParam As Long lParam As Long time As Long pt As POINTAPIEnd

Private Type POINTAPI x As Long y As LongEnd TypePrivate Type MSGTYPE hWnd As Long message As Long wParam As Long lParam As Long time As Long pt As POINTAPIEnd

‘ convert from binary to decimal” NOTE: requires Power2()Function BinToDec(value As String) As Long Dim result As Long, i As Integer, exponent As Integer For i = Len(value) To 1

‘ A clone of VB6’s InstrRev function (including its quirks)’ that works under VB4 and VB5Function InstrRev(StringCheck As String, StringMatch As String, _ Optional Start As Long = -1, Optional

‘ Converts a reference to a file in the standard Windows’ format (e.g. “H:ServerDirFilename.ext”) in the corresponding UNC’ format (e.g. “\ServerNameExportedDirServerDirFileName.txt”)” It turns to be very useful when a program

‘ convert from decimal to binary’ if you pass the Digits argument, the result is truncated’ to that number of digits” NOTE: requires Power2()Function Bin(ByVal value As Long, Optional digits

In T-SQL control statements, you can use the WAITFOR command to delay the execution of a T-SQL batch statement block, stored procedure, or transaction. When you specify the DELAY keyword,

When you use operator typeid, the class type of its argument must be completely defined. This means that a forward declaration of the argument’s base class is insufficient, as in

For humans, the time_t value is unintelligible. The Standard Library defines the struct tm that can represent date and time in a more readable form. The struct tm is declared

In C and C++, time is stored as a positive integer that contains the number of seconds elapsed since January 1st, 1970. The standard type time_t (defined in the header

The C++ Standard Library uses the ANSI C date and time library. Fortunately, the functions and data structures are Y2K compliant, so legacy code that was written nearly 30 years

Creating HTML pages that work well in the various browser versions can be difficult. It is hard to know what features, such as Dynamic HTML and VBScript are supported in

The Visual InterDev 6 toolbox is full of handy design-time controls and HTML shortcuts. As you customize the toolbox, you run a risk of accidentally deleting a tool such as

When you design a Web page using frames, you expect visitors to start at the address of the frameset holder, for example, default.htm. However, people who are linking from a

You can print canned reports in an Access database from VB in different ways. I created this routine to print any report with any criteria or filter from any database.

This code illustrates a VB5 routine that calls a given server’s stored functions or procedures. The first parameter is the stored function procedure name that resides on the server (ORACLE,

You can quickly create IDL (Interactive Data Language) that is compatible with Visual Basic by simply building a server with the Visual Basic IDE that contains the intended interface definitions.

If you’re creating a Jet-based multiuser database system, you’ll sometimes need to know who is currently connected to the shared database. To get this information in situations where you don’t

You should not derive one user-defined COM interface from another user-defined interface when it comes to implementing COM interfaces in VB. A Visual Basic class can inherit from an interface,

Question: I am using a COM object written in Visual C++ using MFC. One of the object methods has a signature like this:void Function(BSTR, BSTR, long*)Whenever I call this method

Question: I am importing an existing site into a Visual InterDev project. However, a key virtual directory is not being included in this import. How can I force/cajole InterDev to

Question: Is there any way to call a function automatically when an ASP page ends? I know about Application_OnEnd and Session_OnEnd but isn’t there any “Page_OnEnd” function or some way

Question: In Visual InterDev I have successfully added a data connection. In the Data View I can see all my tables, fields, etc. My database resides on a SQL 7