|
| MySql - How to retrieve COUNT value |
| Iniciado por Gianni Spano, 14,ene. 2006 09:48 - 5 respuestas |
| |
| | | |
|
| |
Publicado el 14,enero 2006 - 09:48 |
Hello..
I'm aware this can be a stupid (or dummy) question.
Here is my little code:
//
Sql is string
Res is boolean
Sql="SELECT COUNT (*) FROM PRODUCTS"
Res=hExecuteSqlQuery (MyQuery,hquerydefault,sql)
--->>> at this point: How to retrieve the number of records??
//
Sorry, but i didn't find no examples about this...
Pls, can someone point me in the right direction?
Thanks
Gianni |
| |
| |
| | | |
|
| | |
| |
Publicado el 14,enero 2006 - 19:29 |
Gianni
You need to send a parameter to the query and then read the record created.
This should work for you.
myQuery is Data Source
//
sql is string = "SELECT COUNT (*) as Total FROM PickLists"
Res is boolean
Total is int
//
Res=HExecuteSQLQuery(myQuery,hQueryDefault,sql)
//
HReadFirst(myQuery,Total)
WHILE NOT HOut()
//Do your stuff here
Trace(myQuery.Total)
HReadNext
END
HTH
DerekT
Hello..
I'm aware this can be a stupid (or dummy) question.
Here is my little code:
//
Sql is string
Res is boolean
Sql="SELECT COUNT (*) FROM PRODUCTS"
Res=hExecuteSqlQuery (MyQuery,hquerydefault,sql)
--->>> at this point: How to retrieve the number of records??
//
Sorry, but i didn't find no examples about this...
Pls, can someone point me in the right direction?
Thanks
Gianni |
| |
| |
| | | |
|
| | |
| |
Publicado el 14,enero 2006 - 19:29 |
Hi Gianni...
Try with this ...
Res is boolean
MyQuery is Data Source
i is int
Res=HExecuteSQLQuery(MyQuery,"SELECT count(*) AS Count_1 FROM PRODUCTS")
HReadFirst(MyQuery)
i = MyQuery.Count_1
Info(i)
Hello..
I'm aware this can be a stupid (or dummy) question.
Here is my little code:
//
Sql is string
Res is boolean
Sql="SELECT COUNT (*) FROM PRODUCTS"
Res=hExecuteSqlQuery (MyQuery,hquerydefault,sql)
--->>> at this point: How to retrieve the number of records??
//
Sorry, but i didn't find no examples about this...
Pls, can someone point me in the right direction?
Thanks
Gianni |
| |
| |
| | | |
|
| | |
| |
Publicado el 14,enero 2006 - 19:30 |
Hello..
Problem solved..
It was depending from the sql query..
I wrote COUNT (*) with a space between COUNT and (*).
It must be written WITHOUT any space, as COUNT(*).
Thanks
Gianni
Hello..
I'm aware this can be a stupid (or dummy) question.
Here is my little code:
//
Sql is string
Res is boolean
Sql="SELECT COUNT (*) FROM PRODUCTS"
Res=hExecuteSqlQuery (MyQuery,hquerydefault,sql)
--->>> at this point: How to retrieve the number of records??
//
Sorry, but i didn't find no examples about this...
Pls, can someone point me in the right direction?
Thanks
Gianni |
| |
| |
| | | |
|
| | |
| |
Publicado el 15,enero 2006 - 21:53 |
Thanks for your tips, but it does not run. The "Res2" variable is always FALSE.
What i'm trying to retrieve is the number of records read from the INFORMATION_SCHEMA (a db of MySql) to retrieve the number of keys associated to the selected table, based on the 1st query.
//
Sql="SELECT * FROM KEY_COLUMN_USAGE WHERE TABLE_SCHEMA='MyTable' AND TABLE_NAME='Products'"
//
Sql2="SELECT COUNT (*) AS TOTAL FROM KEY_COLUMN_USAGE WHERE TABLE_SCHEMA='MyTable' AND TABLE_NAME='Products'"
//
Res=HExecuteSQLQuery (MyQueryKey,hQueryDefault,Sql)
>> Here the "Res" variable return TRUE and this is correct
Res2=HExecuteSQLQuery (MyQueryCount,Sql2)
Here the "Res2" variable return FALSE, and it is not correct, because there are records that should satisfy the sql query.
Where i'm in wrong?? Do i'm missing somethings?
Thanks
Gianni
Hi Gianni... Try with this ... Res is boolean MyQuery is Data Source i is int Res=HExecuteSQLQuery(MyQuery,"SELECT count(*) AS Count_1 FROM PRODUCTS") HReadFirst(MyQuery) i = MyQuery.Count_1 Info(i) Hello..
I'm aware this can be a stupid (or dummy) question.
Here is my little code:
//
Sql is string
Res is boolean
Sql="SELECT COUNT (*) FROM PRODUCTS"
Res=hExecuteSqlQuery (MyQuery,hquerydefault,sql)
--->>> at this point: How to retrieve the number of records??
//
Sorry, but i didn't find no examples about this...
Pls, can someone point me in the right direction?
Thanks
Gianni |
| |
| |
| | | |
|
| | |
| |
Publicado el 15,enero 2006 - 21:53 |
Gianni
I am pleased you have solved your issue.
Although the actual problem did not seem to bear much in common with your orignal post.
I doubt however that the solution is to do with spaces as the query optimizer will remove all unwanted space before executing the query.
sql is string = "SELECT COUNT (*) as Total FROM PRODUCTS" will run just fine. -- Yes, I just tried it.
Regards
DerekT
Hello.. Problem solved.. It was depending from the sql query.. I wrote COUNT (*) with a space between COUNT and (*). It must be written WITHOUT any space, as COUNT(*). Thanks Gianni Hello..
I'm aware this can be a stupid (or dummy) question.
Here is my little code:
//
Sql is string
Res is boolean
Sql="SELECT COUNT (*) FROM PRODUCTS"
Res=hExecuteSqlQuery (MyQuery,hquerydefault,sql)
--->>> at this point: How to retrieve the number of records??
//
Sorry, but i didn't find no examples about this...
Pls, can someone point me in the right direction?
Thanks
Gianni |
| |
| |
| | | |
|
| | | | |
| | |
|