SQL on paradox - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

SQL on paradox

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

Comments

  • dve83dve83 Posts: 30Member
    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.
  • delhirisdelhiris Posts: 15Member
    Yes, but seems like Delhi can not recognize Fquery.Execute.
Sign In or Register to comment.