On Fri, 2 Feb 2001 11:47:45 +0100, "dizl" <morten.bekkelund@varner.no>
wrote:
>Jeg skal legge inn en ny record i min database med
>obj.AddNew
>
>hvilken verdi skal jeg gi adOpenStatic, LockOptimistic, adCmdText ved
>åpningen av sql setningen min ?
>
>Jeg kan ikke huske forskjellen på verdiene :-\
>
>dizl
>
Here's an example I just copied from one of my own ASP sites:
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set RS = Server.CreateObject("ADODB.RecordSet")
SQL = "Select * From Book"
RS.Open SQL, Conn, adOpenKeyset, adLockOptimistic
I'm not certain what the values mean, but I know I can use RS.AddNew
right after, so it's working.
--
Regards Sir Ghashûl, Knight of The alt.Roundtable <><
ICQ: 7223629
We ain't done till this battle has been fought and won
The victory, how sweet it be, is already ours
Holding the stars, is the man that carries my scars
Always the same, I wear his name with no shame
Here in this Battle Cry, we will never die
-P.O.D. - Tribal
|