Bug #20537 | Param number > 9 => No rows Found | ||
---|---|---|---|
Submitted: | 19 Jun 2006 14:27 | Modified: | 8 Aug 2006 8:01 |
Reporter: | etienne duvett | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | Connector / ODBC | Severity: | S4 (Feature request) |
Version: | 3.51 | OS: | Linux (Gentoo) |
Assigned to: | CPU Architecture: | Any |
[19 Jun 2006 14:27]
etienne duvett
[20 Jun 2006 17:30]
etienne duvett
It's the same as ID 7649
[29 Jun 2006 13:31]
Valeriy Kravchuk
Duplicate of bug #7649, it seems.
[8 Aug 2006 8:00]
etienne duvett
pb project package
Attachment: pb_project.zip (application/x-zip-compressed, text), 14.95 KiB.
[8 Aug 2006 8:01]
etienne duvett
It's the project for bug 7649
[8 Aug 2006 11:17]
etienne duvett
Export of pbl
Attachment: export_pbl.zip (application/x-zip-compressed, text), 5.75 KiB.
[10 Aug 2006 7:16]
etienne duvett
a new version without "showaide"
Attachment: pbmysql.pbl (application/octet-stream, text), 60.50 KiB.
[6 Nov 2006 21:36]
John McQuade
I'm running PB 10.5 and MySQL 5.0.27-community-log. I have this issue in PB 9 as well, I just switched to PB 10.5 and I still have the issue. The trace logs: /*---------------------------------------------------*/ /* 11/6/2006 16:35 */ /*---------------------------------------------------*/ (eb4c10): DIALOG CONNECT TO TRACE ODBC: (eb4c10): DBPARM=ConnectString='DSN=MySQL;UID=root;PWD=rewt;option=135168;database=harris' (23.637 MS / 23.637 MS) (eb4c10): PREPARE WITH BIND VARIABLES: (eb4c10): SELECT tone.SwitchKey , tone.ToneKey , tone.ToneDescription , tone.ToneDefault , tone.ToneIndex , tone.ToneDuration , tone.SilenceDuration , tone.FrequencyOne , tone.AmplitudeOne , tone.FrequencyTwo , tone.AmplitudeTwo FROM tone WHERE ( tone.SwitchKey = ? ) and ( tone.ToneKey = ? ) (eb4c10): FLOAT Length=0 ID=:SwitchKey *1* (eb4c10): FLOAT Length=0 ID=:ToneKey *57* (0.068 MS / 23.705 MS) (eb4c10): BIND SELECT OUTPUT BUFFER (DataWindow): (0.589 MS / 24.294 MS) (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=42,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0 (eb4c10): EXECUTE: (0.336 MS / 24.630 MS) (eb4c10): FETCH NEXT: (0.143 MS / 24.773 MS) (eb4c10): *** DBI_FETCHEND *** (rc 100) (eb4c10): ROLLBACK: (0.003 MS / 24.776 MS)
[7 Nov 2006 1:46]
John McQuade
A setting in the PowerBuilder ODBC INI file (pbodbxx.ini) in the Sybase Shared Directory Add: [MySQL] PBSupportBindSelect='NO' PBSupportBindUpdate='NO' PBSupportDBBind='NO' This resolves the issue.