Unit 'fpsqltree' Package
[Overview][Constants][Types][Classes][Procedures and functions][Index] [#fcl-db]

TSQLSelectStatement

[Properties (by Name)] [Methods (by Name)] [Events (by Name)]

Declaration

Source position: fpsqltree.pp line 792

type TSQLSelectStatement = class(TSQLDMLStatement)

public

  constructor Create(); override;

  destructor Destroy; override;

  function GetAsSQL(); override;

  property TransactionName: TSQLIdentifierName; [rw]

  property Tables: TSQLElementList; [r]

  property Fields: TSQLElementList; [r]

  property Where: TSQLExpression; [rw]

  property GroupBy: TSQLElementList; [r]

  property Having: TSQLExpression; [rw]

  property Orderby: TSQLElementList; [r]

  property ForUpdate: TSQLElementList; [rw]

  property Union: TSQLSelectStatement; [rw]

  property Plan: TSQLSelectPlan; [rw]

  property Limit: TSQLSelectLimit; [r]

  property Distinct: Boolean; [rw]

  property All: Boolean; [rw]

  property UnionAll: Boolean; [rw]

  property StartAt: TSQLExpression; [rw]

  property EndAt: TSQLExpression; [rw]

  property Into: TSQLElementList; [rw]

end;

Inheritance

TSQLSelectStatement

|

TSQLDMLStatement

|

TSQLStatement

|

TSQLElement

|

TObject


Documentation generated on: 2023-03-18