SQL Select Count

[Deepaak]

Code: Pascal  [Select][+][-]

1. Query.sql.text:='Select COUNT(Number) From Table1';
2. Query.ExecuteSql

Error Project Project1 raise exception.

What's Wrong.

[goodname]

First you could try putting it is a try exception block and seeing what error is thrown. Second select statements return data and should use Query.Open; to open a data set.

[taazz]

select commands must always be opened not executed.