October 18th, 2012, 12:52 AM
c++ builder 2007, query count record from database
I have a simple application on C++Builder2007 and access 2007. I want to make a query so when a user hits a button to count the records on a specifiec date. I wrote the above but its not right. I want little help.
The fields are DATE->Date/Time Type... When i hit the button it says invalid integer.. I try to used the ADODATASET component but i dont have problem with that. Can i use something else;;;Like ADOQUERY. Wich is faster?
query="SELECT Count (DATE) FROM DEYAS WHERE DATE= '" + Edit14->Text + "'";
ADODataSet1->CommandText="SELECT COUNT (DATE) FROM BILLS WHERE DATE= '" + Edit14->Text + "'" ;
Last edited by Leite333; October 18th, 2012 at 01:07 AM.
Click Here to Expand Forum to Full Width