PDA

View Full Version : SQLPutData, updating a single field


ebknoppert
03-04-02, 11:21
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.

annavp
03-05-02, 04:05
Hi,
I am not a guru on the odbc subject but shouldn't you use SQLSetPos to update data?
anna

ebknoppert
03-05-02, 05:18
Sure i did.

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

??

ebknoppert
03-06-02, 08:04
Got it.
Concurrency settings enabled :)

Thanks,