SQL on paradox

delhiris

Can i perform SQl question on Paradox table?Plase tell me where can i find some good example.

dve83

as far as I know yes. If you can establish a connection to a paradox db then simply use a TQuery component. SQL syntax is almost standard as I understand (some slight differences). basic statements should be ok.

eg.
[code]FQuery := TQuery.Create;
try
FQuery.SQL.Clear;
FQuery.SQL.Add('Select * from MYTable');
FQuery.Execute;
if FQuery.Active then
ShowMessage(FQuery.FieldbyName('aField').asString);
finally
FreeAndNil(FQuery);
end;[/code]

Hope Im answering the correct question.

delhiris

Yes, but seems like Delhi can not recognize Fquery.Execute.