http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #5 by zxMarce: I will create a FB DB in my machine and will test this. Normally, as per the documentation, ODBC's SQLRowCount() only return a valid row count for INSERT and DELETE statements. But Gambas does need a 'proper' row count. Therefore, I created the GetRecordCount(). What I noticed, but have no idea if it will affect the result, is that your query does not have a column. Please try this query with both calls (SQLRowCount() and GetRecordCount()) to see if it makes a difference: SELECT current_date AS MyDate FROM RDB$DATABASE Thanks. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user