Way 2 Freshers

Referential Integrity (Take care By jet database Engine). Cascade Delete, Cascade Update is done setting property of Attributes.?
DbRelationDeleteCascade, DbRelationUpdateCascade.

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.

Name some date function?
Dateadd(), Datediff(), Datepart(), Cdate()

What is difference between datagrid and flexgrid?
Datagrid Editable. Flexigrid Non-Editable. (Generally used for Read only purpose.)

What are two validate with Data Control?
Data_Validate, Data_Error.

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

What are the Technologies for Accessing Database from Visual Basic?set?
DAO, Data Control, RDO, ODBCDIRECT, ADO, ODBC API , 0040.

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.
What is Mask Edit and why it is used?
Control. Restricted data input as well as formatted data output.

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

ShareThis