ok , now i am using open and this is new code ..
DB.Close;
DB.SQL.Clear;
table.TableName := 'MySmartBB';
DB.Open;
DB.SQL.Add('SELECT * FROM ' + table.TableName + ' ORDER BY id DESC
LIMIT 1,1');
DB.First;
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_;
str_ := DB.Fields[i].AsString;
end;
Memo1.Lines.Add(str_);
DB.Next;
end;
end;
but it's now show this error for me "Missing query , table name or
procedure name."
-----------------------------------------------------
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/
