>
>
>lcSql = "SELECT substring(myField,1,3) AS myField, COUNT(*) AS totItems " +;
> " FROM myTable"+;
> " GROUP BY substr(myField,1,3)"
>
>=SQLEXEC(lnConHandle,lcSql,"myCursor")
>
>? TYPE('myCursor.totItems') -----> "C"
>
>Does anybody know why this happens and if there are any other aggregate functions which return an ummmmmmmmm "unexpected" data type?
>
>FWIW - I got a numeric value by substituting SUM(1) for COUNT(*) but I'm still curious about this.
>
>Thanks to all........Rich
Does mySQL allow to shorten function name to 4 first chars?
If it's not broken, fix it until it is.
My Blog