-
Name some date function
Dateadd(), Datediff(), Datepart(), Cdate()
Sandhya.Kishan
- May 29th, 2012
1.DATE_FORMAT() -Format date as specified
2.DATE_SUB() -Subtract a time value (interval) from a date
3.DATEDIFF() -Subtract two dates
4.DATE_ADD() -Add time values (intervals) to a date value -
What is the max size allowed for Msgbox Prompt and Input Box?
1024
Sandhya.Kishan
- May 29th, 2012
The max size allowed for message box prompt and input box is 1024 bytes.
-
What is keyword used to compare to objects?
ISOperator – Returns Boolean.
-
In project properties if we set Unattended what is it mean?
This cannot have user interface. This can be used for the COM creation.
-
Why we use Treeview Control?
To list the hierarchical list of the node objects. Such of files and Directories.
Sandhya.Kishan
- May 28th, 2012
TreeView control is used to display a hierarchical (or nested, or recursive) collection of data in a tree of expandable nodes.
-
What is Parser Bug?
It is difficult to use database objects declared in a module from within a form.
Sandhya.Kishan
- May 25th, 2012
When a code is in the process of being translated by the compiler and there is an error in the coding such errors are called as parser bug.
-
What is the max size allowed for Max label caption length.
2,048
-
Private Dim x as integer. Valid ?
Private cannot be used in front of DIM.
Sandhya.Kishan
- May 25th, 2012
Private dim x as integer is not valid since private should not be used before dim.
-
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.
Sandhya.Kishan
- May 25th, 2012
Create Object instantiates the object where as Get Object works only with existing instances of an object.
-
What are properties available in Clip Board?
No Properties Available. Only the methods they are SetText, GetText, Setdata(), Getformat(), Clear.
Sandhya.Kishan
- May 25th, 2012
The clip board supports methods and has no properties. It has SetText, GetText, Setdata(), Getformat(), Clear methods.
-
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...
-
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 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.
-
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.
-
DSN Less Connection?
"Server=Oracle; Driver={Microsoft ODBC for Oracle};"
Sandhya.Kishan
- May 24th, 2012
A database connection can be done without using DNS and hence it is called as DNS less.In DNS less method we need to specify the information needed for the connection like database type, server / file...
-
What are the different types of Dialog Box?
Predefined, Custom, User Defined.
Sandhya.Kishan
- May 23rd, 2012
There are two kinds of dialog box namely simple and complex.
Simple dialog box includes information level and error level.
Complex dialog box includes model,modelless and movable levels.
-
What is the max size allowed for Max Control Names length
255.
-
Can We create CGI scripts in VB?
Yes.
-
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 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.
Visual Basic Interview Questions
Ans