-
What is ADO? What are its objects ?
ActiveX Data Object. ADO can access data from both flat files as well as the databases. I.e., It is encapsulation of DAO, RDO, and OLE that is why we call it as OLE-DB Technology. Objects are Connection, Record Set, Command, Parameter, field, Error, Property.
Sandhya.Kishan
- Jul 12th, 2012
ADO stands for Activex Data Object. It is a programming interface to access data in the database and can also access data present in web pages, spreadsheets and other types of documents.
ADO has three objects namely command, connection and record set objects.
-
What is Dataware Control?
Any control bound to Data Control. Ex:- Textbox, Check Box, Picture Box, Image Control, Label, List box, Combo Box, DB Combo,
-
What are two validate with Data Control?
Data_Validate, Data_Error.
-
Record set types and Number available in VB?
3. 1- Dynaset, 0 – Table, 2 – Snap Shot.
Sandhya.Kishan
- May 31st, 2012
There are 5 recordset type available in VB
1.Table-Type Recordset -0
2.Dynaset-Type Recordset -1
3.Snapshot-Type Recordset -2
4.Dynamic-Type Recordset -2
5.Forward only type Recordset -0 -
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...
Sandhya.Kishan
- May 31st, 2012
The locks avaliable in Vb are
1.RdConcurReadOnly 0 (Default)
2.RdConcurLock 1 (Pessimistic Locking)
3.RdConcurRowver 2 (Optimistic Lociking)
4.RdConcurValues 3
5.RdConcurBatch 4 -
How can we call Stored procedure of Back End in RDO and ADO ?
In RDO – We can call using RDO Query Objects. In ADO – We can call using Command Objects.
Sandhya.Kishan
- May 24th, 2012
RDO used RDO query to call stored procedure of a back end where as ADO uses command objects
-
What are the Technologies for Accessing Database from Visual Basic?
DAO, Data Control, RDO, ODBCDIRECT, ADO, ODBC API , 0040.
Sandhya.Kishan
- May 21st, 2012
The technologies for accessing database from visual basic are
1.ADO
2.RDO
3.ODBC
4.ODBC control
5.Data control and
6.ODBC DIRECT -
What is MAPI ?
Messaging Application programming Interface.
Sandhya.Kishan
- May 21st, 2012
MAPI stands for Messaging Application Programming Interface,they provides a consistent interface for multiple application programs to interact with multiple messaging systems across a variety of hardware platforms.
-
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.
Sandhya.Kishan
- May 23rd, 2012
Different types of errors are loading error, runtime error,logical errors,compilation error and syntax error.
-
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.
Sandhya.Kishan
- May 25th, 2012
We use seek method to the objects in the table.It enables us to change the Index property of the Table object to change the order of the Seek. For intensive searches, we may want to create a Table obj...
-
What is Centralization Error Handling?
Writing function and calling it when error occurs.
Sandhya.Kishan
- May 24th, 2012
Centralization error handling is a process of adding a error handling code to an application which is used to handle same errors over and over. Hence we write few procedures that the error-handling code can call to handle common error situations.
-
Handling Error in Calling chain. This will call the top most error where the error is handled.
Sandhya.Kishan
- Jun 18th, 2012
Handling error in calling chain is used to handle the error when we call the top most error.
-
To connect the Data Control with Back end What are all the properties to be set?
Data source Name, Record Source Name
Sandhya.Kishan
- May 24th, 2012
To connect the data control with back end we need to set data source name and record source name.
-
How to trap Data Base Error?
Dim x as RDOError X(0).Des X(1).Number
Sandhya.Kishan
- Jun 18th, 2012
To trap database error we can use PowerBuilder which has a built-in event to capture database errors: it is the DBERROR event in the datawindow.
-
What is view Port?
The area under which the container provides the view of the ActiveX Document is known as a view port.
Sandhya.Kishan
- May 14th, 2012
The container provides an area of view to the ActiveX Document and this is known as a view port.
-
What methods are used for DBGrid in unbound mode?
AddData, EditData, Readdata, WriteData.
Sandhya.Kishan
- May 14th, 2012
The methods used for dbgrid in unbound mode are
1.Readdata
2.Writedata
3.Adddata
4.Editdata. -
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) - 2
Sandhya.Kishan
- May 23rd, 2012
Methods to set the cursor position: positionCursorAfterLast() - Set cursor to after the last record. This method exists so Java programs can use the readPrevious() method to access records in th...
-
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)
Sandhya.Kishan
- Jun 18th, 2012
There are 4 types of recordsets
Dynamic recordsets
Keyset recordsets
Static Recordset
Forward only Recordset
Visual Basic Interview Questions
Ans