Problem with driver ODBC / VB
От | Kalitech |
---|---|
Тема | Problem with driver ODBC / VB |
Дата | |
Msg-id | 00a001c4fe07$ea029340$c565a8c0@LNXP обсуждение исходный текст |
Ответы |
Re: Problem with driver ODBC / VB
|
Список | pgsql-bugs |
Hello, =20 These tests are done with the 2 versions of the driver 7.3 =20 Table User description : u_num int4 nextval( =85), u_comm varchar(512) =20 In my table I have one row :=20 u_num 1 u_comm =91hello world <CR><LF> all is fine.=92 =20 Imagine I want to delete this row Sql =3D =93select * from user where u_num=3D1=94 Set rs =3D odbc_cnx.OpenResultset( sql, rdOpenKeyset, rdConcurRowver ) Rs.Edit Rs.delete Rs.close The row is not deleted. Of course because in the log file, I find Sql =3D =93Delete from user where u_num=3D1 and u_comm=3D=91hel= lo world all is fine.=92=94 =20 I have found how to do : Sql =3D =93select u_num from user where u_num=3D1=94 Set rs =3D odbc_cnx.OpenResultset( sql, rdOpenKeyset, rdConcurRowver ) Rs.Edit Rs.delete Rs.close And now it is ok since in the log file, I find Sql =3D =93Delete from user where u_num=3D1=94 =20 But I have the same problem with update : Sql =3D =93select u_num, u_comm from user where u_num=3D1=94 Set rs =3D odbc_cnx.OpenResultset( sql, rdOpenKeyset, rdConcurRowver ) Rs.Edit Rs(=93u_comm=94).value =3D =93bonjour=94 Rs.update Rs.close In the log file, I find Sql =3D =93Update from user set u_comm=3D=92bonjour=92 where u_= num=3D1 and u_comm=3D=91hello world all is fine.=92=94 Is there anything to do to obtain from the driver something like : Sql =3D =93Update from user set u_comm=3D=92bonjour=92 where u_= num=3D1=94 Since we don=92t need the second clause. =20 Thank you very much if you have a solution. =20 H=E9l=E8ne FESTOC Kalitech - 01 69 41 97 54 =20 =20
В списке pgsql-bugs по дате отправления: