Bug #17342 Executing an count(*) from PowerBuilder 11.5 running in WXP does not run.

• Submitted: 13 Feb 2006 15:40
• Modified: 14 Feb 2006 11:12
• Reporter: Carlos Mejia
• Status: Not a Bug
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 3.51.12
• OS: Windows (XP pro)
• CPU Architecture: Any

[13 Feb 2006 15:40] Carlos Mejia

Description:
I included a script like this:

Select Count(*) Into :li_Found
From Inv_Users
Where Pais = :gi_pais
And UserID = :as_UserID;

But when testing, the system responds with :

"Check de manual that corresponds to your MySQL Server version for the right syntax to use near '*) From Inv_Users Where Pais = '2'....."
 

How to repeat:
I ran this script in the DataBase interactive mode from PowerBuilder and MySql and both ran well. The problem results just when I try to assign the result of Count to a variable.

[14 Feb 2006 11:12] Valeriy Kravchuk

Please, read the manual (http://dev.mysql.com/doc/refman/5.0/en/select.html and http://dev.mysql.com/doc/refman/5.0/en/select-into-statement.html). SELECT ... INTO works only in stored procedures in MySQL.

[10 May 2011 13:32] ANDRES TORRES

La solución es agregar en el dbparm option=135168

Andrés Torres A.
[e-mail]