Opening recordsets as ForwardOnly or ReadOnly makes them move faster between records. In addition, storing fields to variables before begining the loop speeds up field access. Example: * Create a
Most beginners accidentally declare duplicate variables of different data types or of the same data types. The following illustrates this: class Duplicate{ String data; private void fun() { String data=
Uniqueidentifier(GUID) can’t be used in aggregate operations like count(), etc. This problem may be solved by casting uniqueidentifier as varchar. Presuming that guid_column is a uniqueidentifier column: select count(cast(guid_column as
One drawback to presenting data to a browser is that once you have it you can’t manipulate it. With more and more business functions being carried out through the web
‘ The attributes of a file in a readable format.’ It works also with open files, raises an error if the file doesn’t exist.Function GetAttrDescr(filename As String) As String Dim
‘ Returns a collection with the names of all the image’ files in a directory or a directory tree’ this includes all the image types that can be loaded into
Private Const MAX_PATH = 260Private Type SHFILEINFO hIcon As Long iIcon As Long dwAttributes As Long szDisplayName As String * MAX_PATH szTypeName As String * 80End TypePrivate Declare Function SHGetFileInfo
Private Const MAX_PATH = 260Private Type SHFILEINFO hIcon As Long iIcon As Long dwAttributes As Long szDisplayName As String * MAX_PATH szTypeName As String * 80End TypePrivate Declare Function SHGetFileInfo
‘ Returns a collection with the names of all the executable’ files in a directory or a directory tree’ this includes all “exe”, “bat”, “com”, “pif” files” NOTE: Uses the