You will probably have a better response if you post your query to the correct list rather than the sqlite-dev list. It is unlikely that the SQLite3 developers use Delphi, however it is probable that at least one sqlite-user uses delphi ...
Reporting to the correct list. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-dev [mailto:sqlite-dev-boun...@mailinglists.sqlite.org] >On Behalf Of Steve Leonard >Sent: Thursday, 6 December, 2018 18:29 >To: sqlite-...@mailinglists.sqlite.org >Subject: [sqlite-dev] using COUNT(*) in sql from a delphi program > >I have a very basic query like this > >select state, count(*) from customers >group by state > >I am using a Delphi program which displays the data in a dbgrid. > >The problem is the count(*) displays as "WIDEMEMO". > >I have revised the select statement adding "as mycount" like this: > >select state, count(*) as mycount from customers and this runs fine >using other database. > >With SQLITE it has a problem with the field mycount, and when I go >into >the fields editor and add mycount as a new field > >of type aggregate or calculated I have different problems. > >Eventually I found a combination of entries into the "new field" >screen >that works, but the mycount field is blank. > >My attempts to use the delphi "fieldbyname('mycount') do not work. >Does >anyone have a sample Delphi program using SQLITE that displays the >value >of "count(*)"? > >Thank you. > >Steve > > >_______________________________________________ >sqlite-dev mailing list >sqlite-...@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
