Find more freelance jobs
1. How long have you programmed in VB and how would
you rate yourself (1-10)?
2. What does the statement DIM bManager as ... tell
To declare a variable is to tell the program about it
in advance. You declare a variable with the Dim
statement, supplying a name for the variable:
Dim variablename [As type]
Variables declared with the Dim statement within a
procedure exist only as long as the procedure is
executing. When the procedure finishes, the value of
the variable disappears. In addition, the value of a
variable in a procedure is local to that procedure --
that is, you can't access a variable in one procedure
from another procedure. These characteristics allow
you to use the same variable names in different
procedures without worrying about conflicts or
3. What is the difference between Exec and ExecSQL?
(wouldnt this be dependent on data access? Ie ADO use
different method than DAO)
Executes a system procedure, a user-defined stored
procedure, or an extended stored procedure. Also
supports the execution of a character string within a
4.What must the last statement in an exception handler
Program execution resumes with the
statement that caused the error or the most recently
executed call out of the procedure containing the
error-handling routine. Use it to repeat an operation
after correcting the condition that caused the error.
Resumes program execution at the statement
immediately following the one that caused the error.
If the error occurred outside the procedure that
contains the error handler, execution resumes at the
statement immediately following the call to the
procedure wherein the error occurred, if the called
procedure does not have an enabled error handler.
Resumes program execution at the label
specified by line, where line is a line label (or
nonzero line number) that must be in the same
procedure as the error handler.
Err.Raise Number:= number
Triggers a run-time error.
When this statement is executed within the
error-handling routine, Visual Basic searches the
calls list for another error-handling routine. (The
calls list is the chain of procedures invoked to
arrive at the current point of execution. See the
section, "Error-Handling Hierarchy," later in this