(Interview) Visual Basic Interview Questions (Page-9)

Interview : Visual Basic Interview Questions

Page -9

What is MAPI ?
Messaging Application programing Interface.

Different type of Passing Value?
By value, By ref, Optional, Param Array.
Note:- Optional keyword cannot be used while declaring arguments for a function using param array.

What are the different types of error?
Syntax Errors, Runtime , Logic.

What is Seek Method which type of record set is available this?
Only in DbOpenTables.
Syntax: rs.index = "empno"
rs.seek "=" , 10

If with our setting the rs.index then run time error will occur.

What is Centralization Error Handling?
Writing funciton and calling it when error occurs.

Handling Error in Calling chain.
This will call the top most error where the error is handled.

To connect the Data Control with Back end What are all the properties to be set?
Data source Name, Record Source Name

How to trap Data Base Error?
Dim x as RDOError
X(0).Des
X(1).Number

What is view Port?
The area under which the container provides the view of the ActiveX Document is known as a view port.

What methods are used for DBGrid in unbound mode?
AddData, EditData, Readdata, WriteData.

How to increase the Date corresponding with month,date,year?
DateSerial(year(Now),Month(Now)+1,1)
Hour, min, sec, month, year, DateSerial, dateadd, datediff, weekday, datevalue, timeserial,timevalue.

Setting the Cursors.
Default Cursor ? 0
ODBC Cursor (Client side) ? 1
ServerSide Cursors (More Network traffic) - 2Cursor management
Client Batch ? Batch up the Multiple SQL Statements in a single string and Send them to the Server at one time.

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)

Diff types of Lock Types?
RdConcurReadOnly 0 (Default)
RdConcurLock 1 (Pessimistic Locking)
RdConcurRowver 2 (Optimistic Lociking)
RdConcurValues 3
RdConcurBatch 4

What are the RDO Methods and Events?
Methods Events
Begin Trans Validate
Commit Trans Reposition
Rollback Trans Error
Cancel Query Complied
Refresh
Update Controls
Update row

What is Static Cursor?
In ADO Snap Shot is called so.

What is Mixed Cursors?
Static + Keyset

What is FireHouse Cursors?
Forward Only Some time Updateable

What is DBSqlPassThrough?
It will By Passing the Jet Query Processor.

What is DBFailError?
Rolls Back updates if any errors Occurs.

DSN Less Connection?
"Server=Oracle; Driver={Microsoft ODBC for Oracle};"

What is RdExecDirect?
Bypasses the Creation of a stored procedure to execute the query. Does not apply to Oracle.

RdoParameter Object RdoParameterConstant
Direction RdparamInput
RdparamInputOutput
RdParamOutput
Name
Type
Value


Previous | Home