Thomas Chabaud wrote:
> I have a problem with update on recordset with Visual Basic 6.
> I'm using the recordset as following :
> Set rs = New ADODB.Recordset
> rs.Open "SELECT id,myfield1,myfield2,myfield3 from mytable where
> id=6",dbConn, adOpenKeyset, adLockOptimistic, adCmdText
> rs("myfield1").value = myvalue1
> rs("myfield2").value = myvalue2
> rs("myfield3").value = myvalue3
> set rs=Nothing
> But the line is not updated, so I checked the log, and I saw that the
> query which was generated by odbc driver is :
> UPDATE mytable SET myfield1=myvalue1,myfield2=myvalue2,myfield3=myvalue3
> WHERE (id=6 AND myfield1=myvalue1 AND myfield2=myvalue2 AND
> myfield3=myvalue3 )'
Are they really myvalue..s not oldvalue..s after the "AND .." ?
> I wonder why the odbc driver add those "AND ..." statement, because I
> think they are useless, and they fail my rs.update
AFAIK the ODBC driver doesn't add them. Maybe ado does it.
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2006-04-01 06:30:52|
|Subject: Re: Error when getting text longer than MaxLongVarcharSize|
|Previous:||From: Hiroshi Inoue||Date: 2006-04-01 01:35:37|
|Subject: Re: Unicode is not UTF-8. was :psqlODBC-Driver Test / text|