Tip Bank

Question: How do I drop a table column? Answer: To drop a column, use this syntax: ALTER TABLE Employees DROP COLUMN HomePhone Just remember that you can’t drop a column

Question: I have two questions: 1. How can I determine what the server’s lock mode currently is (e.g. WAIT, NO WAIT, etc.), without actually setting it at the same time?

Const HKEY_LOCAL_MACHINE = &H80000002′ Get the path of a Windows application’ or an empty string if the application isn’t registered” this routine only works for those applications that register’ themselves

Const HKEY_LOCAL_MACHINE = &H80000002′ modify the value of a setting for the VB IDE from the Registry’ Important: only works with VB6” New values are effective when VB is restarted”

Const HKEY_LOCAL_MACHINE = &H80000002′ get the list of ODBC drivers through the registry” returns a collection of strings, each one holding the’ name of a driver, e.g. “Microsoft Access Driver

Const HKEY_LOCAL_MACHINE = &H80000002′ Information about the CPU’ you can pass a number 1 to the last argument to retrieve’ information on all the processors in a multi-CPU system” Returns

Const HKEY_LOCAL_MACHINE = &H80000002′ read the name and path of the external HTML editor’ configured for the VB environment” Requires the GetRegistryValue functionFunction GetExternalHTMLEditor() As String ‘ Note that the

Const HKEY_LOCAL_MACHINE = &H80000002′ read the value of a setting for the VB IDE from the Registry’ Important: only works with VB6” Possible values for SettingName are’ AlignToGrid (returns 0/1)’

Const HKEY_LOCAL_MACHINE = &H80000002′ Return the number of processors” Requires the CheckRegistryKey routineFunction GetNumberOfCPUs() As Integer Dim keyName As String ‘ loop on the subkeys of HKEY_LOCAL_MACHINEHardwareDescriptionSystem ‘ CentralProcessor ‘