Hello All,
Thanks for your help. Using Delphi's TmySQL shielded me from rows with
column numbers by providing GetFieldByName().
I made the following little test and can now see exactly where "OneRow[0]"
came from.
:-) :o) :+) :o) :-) (very happy)
Thanks,
Barry.
-------------------
mysql> use authdb
Database changed
mysql> select * from testselect
-> go
+-----+
| Num |
+-----+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
+-----+
5 rows in set (0.00 sec)
mysql> select count(*), max(num) from testselect
-> go
+----------+----------+
| count(*) | max(num) |
+----------+----------+
| 5 | 5 |
+----------+----------+
1 row in set (0.00 sec)
