For SELECT queryies don't use ExecSQL method, use Open or Active :=
True, then, for fetching data into a TMemo, use a code like this:
for i:=0 to DB.RecordCount - 1 do
begin
str_ := '';
for j:=0 to DB.Fields.Count - 1 do
begin
if j >0 then
str_ := str_ + ', ';
str_ := str + DB.Fields[i].AsString;
end;
Memo1.Lines.Add(str_);
end;
> 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 ?
--
Best regards,
Catalin mailto:[EMAIL PROTECTED]
-----------------------------------------------------
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/
