[RESOLVED] ad Question

I often see these things in a vb program does anybody know what these things mean and how they are used.

adOpenDynamic
adOpenForwardOnly
adOpenKeyset
adOpenStatic

adLockBatchOptimistic
adLockOptimistic
adLockPessimistic
adLockReadOnly






Added [RESOLVED] to thread title and green "resolved" checkmark - Hack

Those are named constant values that is declared in the ActiveX Data Objects Library (ADO). They are used to specify how an ADO Recordset should behave. The first 4 define what type of recordset you want to use, and the next 4 deines the lock they will have on the underlaying database.

Look up the Open method for an ADODB.Recordset object in MSDN Library for more information.

thanks :thumb: . One last question. But why does it work even if I don't write those things like

VB Code:

rs.open SQL,Con

Simply because default values are then used, if I remember correctly (without looking it up) the defults are adOpenForwardOnly and adLockReadOnly.

Thanks for the reply.