RdConcurReadOnly 0 (Default) RdConcurLock 1 (Pessimistic Locking) RdConcurRowver 2 (Optimistic Lociking) RdConcurValues 3 RdConcurBatch 4

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by 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

Answer Question  Select Best Answer

In ADO Snap Shot is called so.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by 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...

Answer Question  Select Best Answer

Static + Keyset

sutanu_halder

 Profile Answers by sutanu_halder Questions by 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...

Answer Question  Select Best Answer

Forward Only Some time Updateable

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by 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.

Answer Question  Select Best Answer

It will By Passing the Jet Query Processor.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• May 18th, 2012

Dbsqlpassthrough is a method which helps in jet query processor to by pass.

Answer Question  Select Best Answer

Rolls Back updates if any errors Occurs.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 30th, 2012

It is a property which is used to roll back the updates when an error is encountered.

Answer Question  Select Best Answer

"Server=Oracle; Driver={Microsoft ODBC for Oracle};"

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by 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...

Answer Question  Select Best Answer

Bypasses the Creation of a stored procedure to execute the query. Does not apply to Oracle.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by 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.

Answer Question  Select Best Answer

fsuhail

 Profile Answers by fsuhail Questions by 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...

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 12th, 2012

By using mjwPDF class we can convert a form to PDF in vb.

Answer Question  Select Best Answer

Guna S

• Mar 14th, 2007

hi all i one way to read the excel data if it sis useful use this   Select the microsoft  version x.. from refernce and crate an new application object thru that read the excel fil...

Answer Question  Select Best Answer

How to create xy chart in visual basic like graph where x and y will be provided by us

debasis.yours

 Profile Answers by debasis.yours Questions by 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=

Answer Question  Select Best Answer

kamesh

• Jul 28th, 2006

dear sir,How to access a picture from database(oracle)...

bantisk

 Profile Answers by bantisk Questions by 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 ...

Answer Question  Select Best Answer

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)

bantisk

 Profile Answers by bantisk Questions by bantisk

• Jan 19th, 2006

ListBox and Combo Box

Answer Question  Select Best Answer

vaibhav Tripathi

• Dec 1st, 2006

go to the below process......1.add project 1 to project 2.2.use SYSTEM.DIAGNOSTIC.PROCESS to run the EXE of project2.3.create an object of PROCESS.3.write system.diagnostic.process("....Path...")4.PRO...

Answer Question  Select Best Answer

debasis.yours

 Profile Answers by debasis.yours Questions by debasis.yours

• Nov 26th, 2007

Say you want to change the color of the 1st series of a Chart Control to Black, then use the code below:MSChart1.Plot.SeriesCollection.Item(1).Pen.VtColor.Set 0, 0, 0

Answer Question  Select Best Answer

Jayashree .N Ragavan

• May 12th, 2006

Tree view control is designed to display data that is hierarchical in nature, such as organization trees, the  entries in an index, the files, directories on a disk. It is often used in conjuctio...

Swapna Gentyala

• Mar 18th, 2006

In tree view one entry can have child entry, where as in List view one item can't have any child entries

Answer Question  Select Best Answer

amrita sinha

• May 8th, 2006

Its very simple write a procedure which will build a runtime SQL for you.try thiscreate or replace procedure P_For_Test(PIN_ACCOUNT_NO number)ISstrSQl varchar2(1000);beginstrsql := ' ';strsql := strsq...

sway

• Apr 18th, 2006

--I read somewhere about the following query.--But this is not secure since  @tableName can be replaced by anythingCREATE PROCEDURE dbo.getTable@tableName varchar(50),@fieldName varchar(20) = NUL...

Answer Question  Select Best Answer

ggjo

• Oct 11th, 2006

Use HOOK MENU CONTROL.

fawadali

 Profile Answers by fawadali Questions by fawadali

• Apr 18th, 2006

You would have to use own writter for this

Answer Question  Select Best Answer

shalini

• Nov 6th, 2006

late bindingdim a as objectset a =new server.createobject("adodb.recordset")early bindingdim a as adodb.recordsetset a=new server.createobject("adodb.recordset")

anagha

• Aug 9th, 2006

early binding:eg: dim rs as new adodb.recordsetLate Binding:eg:dim rs as adodb.recordsetset rs=new adodb.recordset

Answer Question  Select Best Answer