"Server=Oracle; Driver={Microsoft ODBC for Oracle};"
2. Calling Stored Procedures in VB?
1. Calling Simply the Procedure with out Arguments "Call ProcedureName}"
2. If it is with Arguments Means then
Declare the Query Def qy
Set Qy as New Query def
Qy.SQL = "{Call ProcedureName(?
4. what will be the result for 15/4 and 154 ?
15/4 = 3.75 and 154 = 3
6. How many procedures are in VB?
2.
function and sub procedures
8. Record set types and Number available in VB?
3.
1- Dynaset, 0 Table, 2 Snap Shot.
10. 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.
11. What methods are used for DBGrid in unbound mode?
AddData,
EditData,
Readdata,
WriteData.
Any control bound to Data Control.
Ex:- Textbox, Check Box, Picture Box, Image Control, Label, List box, Combo Box, DB Combo,
13. What are types of binding?
Assigning variable with defined memory space.
Late Binding - Memory size is allotted in later stage.
Ex:- Dim x as object
Early Binding - Memory size is allotted while declaring itself. New Key word is important.
Ex:- Dim x as New Object
14. 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.
Bypasses the Creation of a stored procedure to execute the query. Does not apply to Oracle.
16. What is Mask Edit and why it is used?
Control. Restricted data input as well as formatted data output.
17. What is the diff between the Create Object and Get object?
Create Object - To create an instance of an object.
Get Object To get the reference to an existing object.
18. What are the Technologies for Accessing Database from Visual Basic?set?
DAO,
Data Control,
RDO,
ODBCDIRECT,
ADO,
ODBC
API ,
0040.
19. To connect the Data Control with Back end What are all the properties to be set?
Data source Name, Record Source Name
20. What are two validate with Data Control?
Data_Validate, Data_Error.
21. What is difference between datagrid and flexgrid?
Datagrid Editable. Flexigrid Non-Editable. (Generally used for Read only purpose.)
Dateadd(),
Datediff(),
Datepart(),
Cdate()
23. 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.
DbRelationDeleteCascade, DbRelationUpdateCascade.
25. How to declare Dll Procedure?
Declare function "" lib ""
Alias "" (Arg, ..) as Return type.
26. How to trap Data Base Error?
Dim x as RDOError
X(0).Des
X(1).Number
Setting the Cursors.
Default Cursor 0
ODBC Cursor (Client side) 1
ServerSide Cursors (More Network traffic) - 2
28. With in the form we want to check all the text box control are typed or not? How?
For each currentcontrol in controls
if typeof currentcontrol is TextBox then
end if
next
29. What is FireHouse Cursors?
Forward Only Some time Updateable
30. What is the max size allowed for Extension in Visual Basic?
Frm,
bas,
cls,
res,
vbx,
ocx,
frx,
vbp,
exe
31. What is the diff. Between function and sub procedures?
Function will return value but a sub procedure wont return values
32. What is diff between the Generic Variable and Specific Variable?
Generic Variable:
Create Object Ex:-Ole-Automation . No need refer the object library.
Specific Variable:
Binding Procedure Early and Late Binding ( Can be Remove from the Memory).
33. 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.
34. How to check the condition in Msgbox?
If(Msgbox("Do you want to delete this Record",VbYesNo)=VbYes)Then End if
35. What is Static Cursor in VB?
In ADO Snap Shot is called so.
