On Thu, 2012-04-05 at 21:17 -0400, ron...@rrgweb.net wrote:
Your problem is with your SQL Query I Think ?
$hConn.Exec("use AddressBook;")
iData = $hConn.Exec("select count(*) AS RecCount from Addresses")
PRINT iData!RecCount
Does this work ?
Cheers,
Ian Roper - Perth Western Australia
---
From: ron...@rrgweb.net
To: gambas-user@lists.sourceforge.net
Sent: Thu, 5 Apr 2012 21:17:52 -0400
Subject: [Gambas-user] Problem with row count in mysql
> I am having trouble getting a row count using mysql. Here is some sample
> code I have used. All else works and I can connect
I am having trouble getting a row count using mysql. Here is some sample
code I have used. All else works and I can connect to the database and
table.
There are 4 rows in the Table called Addresses. Running this program
shows iData and 'a' as having 0 rows. Please advise.
Thank you
Ron
Examp