Results 1 to 10 of 10
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write in rset... (2000)

    What is the error message that you get?

    The value of Test_Data isn't defined anywhere in the code.
    You have commented out the line that updates the record.

  2. #2
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Write in rset... (2000)

    the var is alreday filed (i have dimensioned in globat)
    In other case the first error i have in

    OggettoRecordset.Fields("ELAB") = "OK"

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write in rset... (2000)

    Try changing the line

    Set OggettoRecordset = OggettoConnessione.Execute("SELECT * FROM " & TABELLA & "")

    to

    OggettoRecordset.Open "Tabella", OggettoConnessione, adOpenKeyset, adLockOptimistic, adCmdTableDirect

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Write in rset... (2000)

    Why have error in when i write a new value in curent rset...
    error here:

    OggettoRecordset.Fields("ELAB") = "OK"
    OggettoRecordset.Fields("DATA_ELAB") = TEST_DATA

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write in rset... (2000)

    Why have you deleted the attachment? You have made this thread incomprehensible to others.

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Write in rset... (2000)

    Sorry! instead to replace attachment with new file i have deleted;-(...
    i re attach new file now...

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write in rset... (2000)

    <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write in rset... (2000)

    It works OK for me.

  9. #9
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Write in rset... (2000)

    Sorry...
    in other case with the last your suggetsion have error 3001...

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Write in rset... (2000)

    You have removed the attachment again. Thread locked.

Posting Permissions

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