SQL on paradox

Tue, 06 Jan 2009 11:02:42 -0700

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

Re: SQL on paradox

Wed, 07 Jan 2009 07:57:22 -0700

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.

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;

Hope Im answering the correct question.

Re: SQL on paradox

Fri, 09 Jan 2009 11:55:49 -0700

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

'SQL on paradox' Thread RSS Feed

SQL on paradox

Re: SQL on paradox

Re: SQL on paradox