: Friday, August 08, 2003 12:17 AM
To: Fatt Shin
Cc: [EMAIL PROTECTED]
Subject: Re: select count(*) Problem in PowerBuilder Thru MySQL ODBC
3.51
You are not doing select count(*)
You are doing select count ( *)
Get rid of the spaces before the (
Fatt Shin wrote:
Hi,
I'm running MySQL 4.0.13
Hi,
I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB
Connector 3.51.
I'm facing a problem where whenever I issue a SELECT COUNT(*) statement
from PowerBuilder, I always get SQL syntax error back from MySQL. (Refer
to ODBC Trace I captured below).
metrohouse af8-b94 ENTER
Try this ...
Delete from clients where 0 = (select count(*) from branches where branches.cid =
clients.cid)
Cheers
FattShin
-Original Message-
From: Vikram Vaswani [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:51 PM
To: Nils Valentin; [EMAIL PROTECTED]
Subject: Re: Help with