Answer / guest

CURSORS::
*********
The cursor types are listed from least to most resource
intensive.
Forward Only - Fastest, can only move forward in recordset
Static - Can move to any record in the recordset. Data is
static and never changes.
KeySet - Changes are detectable, records that are deleted
by other users are unavailable, and records created by
other users are not detected
Dynamic - All changes are visible.

LOCKING TYPES::
****************
LockPessimistic - Locks the row once after any edits occur.
LockOptimistic - Locks the row only when Update is called.
LockBatchOptimistic - Allows Batch Updates.
LockReadOnly - Read only. Cannot alter the data.

What is the difference between queryunload and unload in form?

2 Answers  

---

How do you clear the current selected item from a drop down combo box?

2 Answers  

---

what is the Difference between Declaration and Instantiation an object?

1 Answers  

---

What are the properties of datacontrol?

0 Answers  

---

Advantage of ActiveX Dll over Active Exe.

0 Answers  

---

What is Seek Method which type of record set is available this?

0 Answers  

---

How do I make a text box not beep but do something else when I hit the Enter key?

0 Answers  

---

How can I create a VBX?

0 Answers  

---

what is the difference between procedures,attributes and functions?

1 Answers   Microsoft, Patni,

---

What will happen if you issue a Resume statement after handling an error?

3 Answers  

---

what are the Parts of ODBC?

0 Answers  

---

What language does visual basic use?

0 Answers  

---