-
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 -
Diff types of Lock Types?
RdConcurReadOnly 0 (Default) RdConcurLock 1 (Pessimistic Locking) RdConcurRowver 2 (Optimistic Lociking) RdConcurValues 3 RdConcurBatch 4
Sandhya.Kishan
- Jun 18th, 2012
Different types of lock types:
RdConcurReadOnly 0 (Default)
RdConcurLock 1 (Pessimistic Locking)
RdConcurRowver 2 (Optimistic Locking)
RdConcurValues 3
RdConcurBatch 4 -
What is Static Cursor?
In ADO Snap Shot is called so.
Sandhya.Kishan
- Apr 30th, 2012
A cursor which can move to any record in the record set is known as a static cursor They support forward and backward scrolling but they do not support updates. are either read-only or read/write.Stat...
-
What is Mixed Cursors?
Static + Keyset
sutanu_halder
- Dec 14th, 2007
A mixed cursor is a combination of a keyset-driven cursor and a dynamic cursor. It is used when the result set is too large to reasonably save keys for the entire result set. Mixed cursors are impleme...
-
What is FireHouse Cursors?
Forward Only Some time Updateable
Sandhya.Kishan
- Apr 30th, 2012
Firehouse cursor is the default cursor that allows only forward movement through the cursor. These cursors are up-datable sometimes.
-
What is DBSqlPassThrough?
It will By Passing the Jet Query Processor.
Sandhya.Kishan
- May 18th, 2012
Dbsqlpassthrough is a method which helps in jet query processor to by pass.
-
What is DBFailError?
Rolls Back updates if any errors Occurs.
Sandhya.Kishan
- Apr 30th, 2012
It is a property which is used to roll back the updates when an error is encountered.
-
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 is RdExecDirect?
Bypasses the Creation of a stored procedure to execute the query. Does not apply to Oracle.
Sandhya.Kishan
- May 21st, 2012
RdExecdirect is a function which is used to bypass the creation of stored procedure. It bypassed the stored procedure to execute a query.
-
Explain the usage of thse prameters Split, Mid, instr?
fsuhail
- Feb 17th, 2007
SPLIT-------Returns a zero-based, one-dimensional array from a specified number of substringsExample:dim sstr as stringdim arr() as Arraysstr="My name is Harry"arr()=split(sstr)'arr() wi...
-
How to convert a form that contain some chart and some textbox to PDF in Visual Basic ?
-
-
XY Chart
How to create xy chart in visual basic like graph where x and y will be provided by us
debasis.yours
- Nov 26th, 2007
You can perform this by using Microsoft Chart Control and setting ChartType to "VtChChartType2dLine". After that, take a two dimentional array and store the (X,Y) values into the array. After that just assign the array to the chartData property likeMSChart1.ChartData=
-
How to access a picture from database(oracle) into VB Form and to store back to database.
kamesh
- Jul 28th, 2006
dear sir,How to access a picture from database(oracle)...
bantisk
- Jan 19th, 2006
you need to create a BLOB field in oracle and in VB open the photo file in binary and use the record sources AppendChunk method to store binary data to BLOB field.and to access the photo from DB use ...
-
Clear property is available to which control
Combo box control
Sovan Naskar
- Jul 14th, 2006
Clear property available listbox, combo box and all?grids (db grid,microsoft flex grid, microsoft Hierarchal flex grid, vsflex grid etc)
Visual Basic Interview Questions
Ans