RTFM, especially on TSQLQuery.ExecSQL, as it says on the bottom of that page:
"Note: Do not use ExecSQL for commands such as SELECT queries that return data. When the command returns data, use the Open method or set the Active property to true." (So, use "Open", in which case the component will contain the returned data. ) Walter ----- Original Message ----- From: "smart9dotcom" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, July 07, 2005 9:11 AM Subject: [list] [delphi-en] fetch info with dbExpress ? > Hello .. > > i am using dbExpress with MySQL , i written this code : > > DB.Close; > DB.SQL.Clear; > DB.SQL.Add('SELECT * FROM MySBB_subject ORDER BY id DESC LIMIT 1,1'); > DB.ExecSQL; > Memo1.Lines.Add(SM.TraceList.Text); > > but i don't know how i can fetcho info now ? ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
