Hi !!! > -----Original Message----- > From: Cenk Akyüz [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 1:55 AM > To: [EMAIL PROTECTED] > Subject: MyODBC:Update with SQLSetPos doesnt work with some "kind of" > primary keys? > > > MySQL Version: 3.23.42-max-nt > MyODBC Version:2.50.39 > OS Version= Windows 2000 Server > > > If I change the order of fields in a multi-column primary key table, > I cant update the table with SQLSetPos. > ie: If I declare my table :(Primary key fields's order is the same > as in table) > create table A( name varchar(20) not null, surname varchar(20) not > null, addresss varchar(50), constraint pkA primary key(name, surname )) > insert into A(name, surname) values('Bill', 'Gates') > select * from A > It works. > But If I declare primary key like this > create table A( name varchar(20) not null, surname varchar(20) not > null, addresss varchar(50), constraint pkA primary key(surname, name )) > It doesnt work. > It doesnt give any error, but doesnt update any row. > the output is : > SQLSetPos: > Operation = SQL_UPDATE=2, LockType = SQL_LOCK_NO_CHANGE=0 > Return: SQL_SUCCESS_WITH_INFO=1 > stmt: szSqlState = "01S03", > *pfNativeError = 0, *pcbErrorMsg = 36 > > szErrorMsg = "[TCX][MyODBC]No rows updated/deleted"
Thanks for the bug. That was a silly mistake in passing the bind parameter number for internal binding, now I fixed this and it will be available for MyODBC-2.50.40. You can also find the intermittent driver with the fix, from ftp://support.mysql.com/pub/mysql/hidden/myodbc/myodbc-39-win32.zip and let me know outcome of it. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
