RecordSet Instruction

Results 1 to 5 of 5

Thread: RecordSet Instruction

  1. #1
    Tink Guest

    Default RecordSet Instruction

    In This Code<BR><BR> sql, conn, 0, 0<BR>if im right they range from 0 - 3<BR>whats the value of each number

  2. #2
    cant Guest

    Default RE: RecordSet Instruction

    First Number is cursor type<BR>adOpenForwardOnly = 0<BR>adOpenKeyset = 1<BR>adOpenDynamic = 2<BR>adOpenStatic = 3<BR><BR>Second is lock type<BR>adLockReadOnly = 1<BR>adLockPessimistic = 2<BR>adLockOptimistic = 3<BR>adLockBatchOptimistic = 4<BR><BR>And there is a third, options<BR>

  3. #3
    Tink Guest

    Default RE: RecordSet Instruction

    Im having with the Code its giving me a Object Required Error: "<BR><BR>Is the problem deals with this Connection?

  4. #4
    Chaveiro Guest

    Default RE: RecordSet Instruction

    probably you dont open the Connection (Set conn = Server.... then blabla)<BR>or you dont do that: Set Rs = Server.CreateObject("ADODB.Recordset")<BR>...<BR>< BR>hope was useful...<BR>Chaveiro<BR>

  5. #5
    Tink Guest

    Default RE: RecordSet Instruction

    Is it okey to have 2 Recordset in one connection?<BR><BR>because that&#039;s the thing that i must do in order to open both fields that is needed in order to compute the specific value for a given instruction

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts