How to trap Data Base Error?
Dim x as RDOError X(0).Des X(1).Number Read more »
Dim x as RDOError X(0).Des X(1).Number Read more »
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. Read more »
Only in DbOpenTables. Syntax: rs.index = “empno” rs.seek “=” , 10 If with our setting the rs.index then run time error will occur. Read more »
Calling Simply the Procedure with out Arguments “Call ProcedureName}” If it is with Arguments Means then Declare the Query Def qy Set Qy as New Query... Read more »
DAO, Data Control, RDO, ODBCDIRECT, ADO, ODBC API. Read more »
Microsoft ODBC driver will support all the methods and properties of Visual Basic. Where as the Oracle not. Read more »
In RDO – We can call using RDO Query Objects. In ADO – We can call using Command Objects. Read more »
RDO is Hierarchy model where as ADO is Object model. ADO can access data from both flat files as well as the data bases. I.e., It is encapsulation of DAO, RDO, OLE... Read more »
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.Read... Read more »
Any control bound to Data Control. Ex:- Textbox, Check Box, Picture Box, Image Control, Label, List box, Combo Box, DB Combo, Read more »
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... Read more »
Datagrid – Editable. Flexigrid – Non-Editable. (Generally used for Read only purpose.) Read more »
It is difficult to use database objects declared in a module from within a form. Read more »
Simple –Single Select , Extended. – Multiple Select. Read more »
Simple, Dropdown list – We can type and select. Dropdown Combo – Only Drop Down. Read more »