MySQL Bugs: #7183: No find the registry with a primary key.

Bug #7183	No find the registry with a primary key.
Submitted:	10 Dec 2004 22:04	Modified:	30 May 2013 12:12
Reporter:	Luenchy Luenchy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51.10	OS:	Windows (Window all)
Assigned to:		CPU Architecture:	Any

Description:
      In PowerBuilder 8 using MyODBC, when going to find a registry that have a Primary Key don't find. Help me please I need the solution
      

How to repeat:
I don't know, please help me

Sorry but you need to elaborate better how you are getting that,
below using an ODBC test tool I queried a table with id as primary
key:

SQLExecDirect:
In:				hstmt = 0x003A1700, 
szSqlStr = "select  name from testbug where id=1", cbSqlStr = -Return:	SQL_SUCCESS=0

Get Data All:
"name"
"Mary"
1 row fetched from 1 column.

I so sorry, well, the problem is when the primary key is two number, for example 10, 11, 12 , etc, when is one number for example 1, 2, 3 work it fine, please help me. I work with PowerBuilder 8, snd use the datawindow, I look you a example

datastore ds_data 
ds_data = create datastore

ds_data.dataobject = "name of datawindow"
ds_data.settransobject(SQLCA)

if ds_data.retrieve(number) > 0 then
end if

Sorry but with the sample you supplied I can't help you
also because I don't know PowerBuilder8 but with your
description of the issue I don't have problems with 
another client language application like Access. So
at first glance I assume isn't Connector/ODBC issue.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.