Tip Bank

DevX - Software Development Resource

CConsole – A class for creating console applications

‘ CCONSOLE Class” Creates a console window and writes to it’ Example:’ Dim cons As New CConsole’ cons.WriteString “Hello World”Private Declare Function AllocConsole Lib “kernel32” () As LongPrivate Declare Function

DevX - Software Development Resource

Display the Windows Shortcut Wizard

You can programmatically start the Shortcut Wizard from your code, to give the end user the capability to create a new shortcut: Shell “rundll32.exe AppWiz.Cpl, NewLinkHere ” & App.Path, 1

DevX - Software Development Resource

ShowIcon – Extract an icon from a file and show it

Private Declare Function ExtractIcon Lib “shell32.dll” Alias “ExtractIconA” _ (ByVal hInst As Long, ByVal lpszExeFileName As String, _ ByVal nIconIndex As Long) As LongPrivate Declare Function DrawIcon Lib “user32” (ByVal

DevX - Software Development Resource

Using ROWNUM To Retrieve

It is often necessary to get a list of values from multiple rows. Generally, this is done using the cursor, which tends to make the task more complicated.I tried to