Hi guys, I have a simple ACCESS database data.mdb that I want to be able to communicate with in my program (using BCB 5 Ent). I set it all up using the ADOConnection component to connect to the database, then I am using the ADOQuery component to post SQL commands to the database. This is working great and all but,, How the heck can I work with my results from the ADOQuery?
Say I run this statement "SELECT * FROM datatable WHERE rats='cheese'"
Okay great, works, but I want to work with the results in my coding - not on a DBGrid. I want to be able to chop at the results with my code and display what I want to the end user in my own Memo or something...
For instance, say I want to display on a Label that 5 of the results contain the letter "A" in the name column.
Say I run this statement "SELECT * FROM datatable WHERE rats='cheese'"
Okay great, works, but I want to work with the results in my coding - not on a DBGrid. I want to be able to chop at the results with my code and display what I want to the end user in my own Memo or something...
For instance, say I want to display on a Label that 5 of the results contain the letter "A" in the name column.