Use the GetSafeArrayInfo function to rip the lid off a SAFEARRAY. It allows the caller to identify the number of dimensions and number of elements for each dimension (among other
This tip is for SQL Server 6.5 and up. When debugging a SELECT query, add an absolute true condition as the first condition of the WHERE clause: SELECT au_lname, au_fnameFROM
To use the FileSystemObject, you need to reference the Microsoft Scripting Runtime: Public Function GetExecutableFileVersion(ByVal _ Filename As String) As String Dim FileObj As Scripting.FileSystemObject ‘ Create Object Set FileObj
When you call a stored procedure in SQL Server that performs data manipulation on the database from a Microsoft Transaction Server (MTS) transaction, let MTS handle all the transaction management.
Many VB objects have KeyDown, KeyUp, MouseDown, MouseUp, and MouseMove events. They
Oracle and SQL Server treat strings slightly differently
This tip works with ASP/IIS 4.0 and up. Many companies sell ActiveX objects for uploading files to Active Server Pages. However, you can easily write a bit of VBScript to