Re: [Gambas-user] Problem with row count in mysql

2012-04-05 Thread Ian Roper
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

Re: [Gambas-user] Problem with row count in mysql

2012-04-05 Thread nando
--- 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

[Gambas-user] Problem with row count in mysql

2012-04-05 Thread ronald
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