revQueryDatabase returns different result sets compared to revDataFromQuery
Posted: Wed Dec 09, 2020 11:52 pm
LC 9.5.1 stable, Windows 10, IDE
So far, I used the database function revDataFromQuery(tab, CR, gConnectionID, tSQLStatement) on MySQl. It works fine. Now I need to retrieve blobs and started working with revQueryDatabase(gConnectionID,tSQLStatment) ... then taking the resulting cursor to retrieve the records using the recommended "convertCursorToArray @tResultA" as demonstrated in the Tutorials.
The first test query is simplest: "SELECT * FROM note" where "note" is the table name.
The second simple query: "SELECT note.id, note.desc, note.ts FROM note". (The MySQL I am using requires the table name in front of each column name.)
What is very strange is the result set:
1. revDataFromQuery returns 79 records in both queries -- and that is all there is.
2. revQueryDatabase returns 27 records only when using the second query, Why not all 79?
3. revQueryDatabase returns 20 records with the first query, why not all, and why different from 2.?
Is there a reason? Is there something I am missing? I could post the scripts if needed, but why even the same function call returns two different sets of data is a mystery to me.
Thanks for any insight...
So far, I used the database function revDataFromQuery(tab, CR, gConnectionID, tSQLStatement) on MySQl. It works fine. Now I need to retrieve blobs and started working with revQueryDatabase(gConnectionID,tSQLStatment) ... then taking the resulting cursor to retrieve the records using the recommended "convertCursorToArray @tResultA" as demonstrated in the Tutorials.
The first test query is simplest: "SELECT * FROM note" where "note" is the table name.
The second simple query: "SELECT note.id, note.desc, note.ts FROM note". (The MySQL I am using requires the table name in front of each column name.)
What is very strange is the result set:
1. revDataFromQuery returns 79 records in both queries -- and that is all there is.
2. revQueryDatabase returns 27 records only when using the second query, Why not all 79?
3. revQueryDatabase returns 20 records with the first query, why not all, and why different from 2.?
Is there a reason? Is there something I am missing? I could post the scripts if needed, but why even the same function call returns two different sets of data is a mystery to me.
Thanks for any insight...