Home > Back-end >  Delphi firebird clientdataset (select count (*)) strange questions, seek solutions.
Delphi firebird clientdataset (select count (*)) strange questions, seek solutions.

Time:10-13

Table: myTable
Fields: FKEY: integer, FNAME: string
The server-side DataSetProvide poAllowCommandText is set to True,
Client:
ClientDataSet.com mandtext:='select * from myTable'; Execution is normal, and returns the data

ClientDataSet.com mandtext:='select count (*) from myTable'; Abnormal program
ClientDataSet.com mandtext:='select count (*) as ret_count from myTable'; Abnormal program
Trying
ClientDataSet.com mandtext:='select FNAME from myTable'; Abnormal program

This is how to return a responsibility?
I direct execution in the FireBird controller select count (*) from myTable no errors,
  • Related