-
-
-
-
-
-
How to trap Data Base Error?
Dim x as RDOError X(0).Des X(1).Number
-
-
Diff types of Lock Types?
RdConcurReadOnly 0 (Default) RdConcurLock 1 (Pessimistic Locking) RdConcurRowver 2 (Optimistic Lociking) RdConcurValues 3 RdConcurBatch 4
-
What are the record set types?
RdOpenFowardOnly 0 (Default used only for the read only purpose) RdOpenStatic 1 RdOpenDynamic 2 RdOpenKeySet 3 (Normally used for the live project)
-
Different type of Instantiation?
Private – Only for the Specific Module. Public not creatable – Private & Public Multi Use - Variable we have to declare. Single Use – Not possible through dll. Global Multiuse – Have variable not Required to Declare. Global Single Use - Only for exe.
-
What is the difference between Property Get, Set and Let?
Set – Value is assigned to ActiveX Object from the form. Let – Value is retried to ActiveX Object from the form. Get- Assigns the value of an expression to a variable or property.
-
What are the locks available in Visual Basic?
Locking is the process by which a DBMS restricts access to a row in a multi-user environment 4 types of locks. They are 1. Batch Optimistic 2. Optimistic 3. Pessimistic 4. ReadOnly Operations in a relational database act on a complete set of rows. The set of rows returned by a SELECT statement consists of all the rows that satisfy the conditions in the WHERE clause of the statement. This complete set...
-
Record set types and Number available in VB?
3. 1- Dynaset, 0 – Table, 2 – Snap Shot.
-
Where will we give the option explicit keyword and for what?
In the general declarations section. To trap undeclared variables.
-
What is control array and how many we can have it with in the form?
Group of control share the same name. Max 32, 767.
-
-
What is the diff. Between function and sub procedures
) Function will return value but a sub procedure wont return values…
-
What is Friend Variable?
Scope sharable between projects.
-
What is the return type of Instr and Strcmp?
Instr – integer (Numeric position)Strcmp - integer ( if both the string are equal they result = 0) Strcmp (Str1, Str2, Comparetype) Comparing mode = 0 – Binary Comparing 1 – Textual Comparing
-
Visual Basic Interview Questions
Ans