Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Location
    Netherlands
    Posts
    3

    Unanswered: SQLPutData, updating a single field

    I have an stmt using keyset driven mode.
    It's very simple, as i need a field data i set the field pos and get the data using SQLGetdata()
    No cursor stuff or parameter or bindcols whatsoever.

    I would like to use THIS method to build an field update without SQL.

    I tried SQLPutData but the field is not updated.

    MSDN shows parameter stuff but i'm not so clever with this.
    I don't want to use bindcol, except if there is no other way.

  2. #2
    Join Date
    Feb 2002
    Location
    Leuven, Belgium
    Posts
    27

    SQLSetPos

    Hi,
    I am not a guru on the odbc subject but shouldn't you use SQLSetPos to update data?
    anna

  3. #3
    Join Date
    Mar 2002
    Location
    Netherlands
    Posts
    3
    Sure i did.

    PutData, setpos with update flag.
    Mixed/tried with a late call to bincols for this col only etc..

    ??

  4. #4
    Join Date
    Mar 2002
    Location
    Netherlands
    Posts
    3
    Got it.
    Concurrency settings enabled

    Thanks,

Posting Permissions

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