simple dbexpress query question.
Posted on 2003-04-01
I'm currently teaching myself Kylix/Delphi, and am trying to do some stuff with a MySQL DB. I am able to use the SQLQuery component to do inserts and updates so far, but something I need to do right now is get some information from a select statement. Actually a very simple one: "SELECT (count(id)+1) FROM messages"
creating the component with the SQL is simple, I am unsure how to retrieve the results though, I want it back as a simple string.