Osztály TDBQueryHelper
Egység
Deklaráció
type TDBQueryHelper = class(TObject)
Megjegyzés
This item has no description.
Hierarchia
- TObject
- TDBQueryHelper
Áttekintés
Metódusok
 |
function Create: TDBQueryHelper; |
|
procedure Clear; |
|
function Database(ADatabase: TFDConnection): TDBQueryHelper; |
|
function SQL(AQuery: string): TDBQueryHelper; |
|
function Select(AFields: string): TDBQueryHelper; |
|
function Select_(AFields: array of string): TDBQueryHelper; |
|
function First(ACount: LongInt): TDBQueryHelper; |
|
function Distinct: TDBQueryHelper; |
|
function From(ATable: string): TDBQueryHelper; |
|
function Join(ATable: string): TDBQueryHelper; |
|
function InnerJoin(ATable: string): TDBQueryHelper; |
|
function LeftJoin(ATable: string): TDBQueryHelper; |
|
function RightJoin(ATable: string): TDBQueryHelper; |
|
function _On(AFilter: string): TDBQueryHelper; |
|
function Where(AFilter: string): TDBQueryHelper; |
|
function Where_(AFilter: string; AParameters: array of variant): TDBQueryHelper; |
|
function _And(AFilter: string): TDBQueryHelper; |
|
function _Or(AFilter: string): TDBQueryHelper; |
|
function OrderBy(AFields: string): TDBQueryHelper; |
|
function OrderBy_(AFields: array of string): TDBQueryHelper; |
|
function GroupBy(AFields: string): TDBQueryHelper; |
|
function GroupBy_(AFields: array of string): TDBQueryHelper; |
|
function Insert(ATable: string): TDBQueryHelper; |
|
function Fields(AFields: string): TDBQueryHelper; |
|
function Fields_(AFields: array of string): TDBQueryHelper; |
|
function Values(AValues: array of variant): TDBQueryHelper; |
|
function Value(AFieldName: string; AValue: Variant): TDBQueryHelper; |
|
function Returning(AFields: string): TDBQueryHelper; |
|
function Returning_(AFields: array of string): TDBQueryHelper; |
|
function Return(AField: string): Variant; |
|
function Update(ATable: string): TDBQueryHelper; |
|
function UpdateOrInsert(ATable: string): TDBQueryHelper; |
|
function Matching(AFields: string): TDBQueryHelper; |
|
function Matching_(AFields: array of string): TDBQueryHelper; |
|
function Delete(ATable: string): TDBQueryHelper; |
|
function Parameter(AParameter: string; AValue: Variant): TDBQueryHelper; |
|
function ClearTableKeyMapping: TDBQueryHelper; |
|
function SetupTableKeyMapping(AList: TStrings): TDBQueryHelper; |
|
function SetupTableKeyMappingFromString(AList: string): TDBQueryHelper; |
|
function SetupTableKeyMappingFromArray(AList: TArrayOfStringPairs): TDBQueryHelper; |
|
function Load(ATable: string; AValue: Variant): TDBQueryHelper; |
|
function LoadID(ATable: string; AField: string; AValue: Variant): TDBQueryHelper; |
|
function Edit: TDBQueryHelper; |
|
function Store: TDBQueryHelper; |
|
function New(ATable: string): TDBQueryHelper; |
|
function NewID(ATable: string; AField: string): TDBQueryHelper; |
|
function Modify(ATable: string; AValue: Variant): TDBQueryHelper; |
|
function ModifyID(ATable: string; AField: string; AValue: Variant): TDBQueryHelper; |
|
function ModifyOrNew(ATable: string; AMatching: string): TDBQueryHelper; |
|
function ModifyOrNew_(ATable: string; AMatching: array of string): TDBQueryHelper; |
|
function ModifyOrNewID(ATable: string; AField: string; AMatching: string): TDBQueryHelper; |
|
function ModifyOrNewID_(ATable: string; AField: string; AMatching: array of string): TDBQueryHelper; |
|
function Purge(ATable: string; AValue: Variant): TDBQueryHelper; |
|
function PurgeID(ATable: string; AField: string; AValue: Variant): TDBQueryHelper; |
|
function GetID: Variant; |
|
function Execute: TDBQueryHelper; |
|
function Dataset: TDataSet; |
|
function Clone: TDataSet; |
|
function FetchAll(ATable: string; AFields: string; AFilter: string; AOrder: string): TDBQueryHelper; |
|
function FetchAll_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant; AOrder: array of string): TDBQueryHelper; |
|
function Fetch(ATable: string; AFields: string; AFilter: string; AOrder: string): TDBQueryHelper; |
|
function Fetch_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant; AOrder: array of string): TDBQueryHelper; |
|
function Count(ATable: string; AFields: string; AFilter: string): Variant; |
|
function Count_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
function Sum(ATable: string; AFields: string; AFilter: string): Variant; |
|
function Sum_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
function Min(ATable: string; AFields: string; AFilter: string): Variant; |
|
function Min_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
function Max(ATable: string; AFields: string; AFilter: string): Variant; |
|
function Max_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
function Avg(ATable: string; AFields: string; AFilter: string): Variant; |
|
function Avg_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
function JumpFirst: TDBQueryHelper; |
|
function JumpLast: TDBQueryHelper; |
|
function Next: Boolean; |
|
function Prior: Boolean; |
|
function EOF: Boolean; |
|
function BOF: Boolean; |
|
function StartTransaction: TDBQueryHelper; |
|
function Commit: TDBQueryHelper; |
|
function Rollback: TDBQueryHelper; |
Tulajdonságok
|
property DateFormat: string; |
|
property TimeFormat: string; |
|
property DateTimeFormat: string; |
|
property _[param1: Variant]: TField; |
Megjegyzés
Metódusok
|
function Create: TDBQueryHelper; |
|
This item has no description. | |
|
procedure Clear; |
|
This item has no description. | |
|
function Database(ADatabase: TFDConnection): TDBQueryHelper; |
|
This item has no description. | |
|
function SQL(AQuery: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Select(AFields: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Select_(AFields: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function First(ACount: LongInt): TDBQueryHelper; |
|
This item has no description. | |
|
function Distinct: TDBQueryHelper; |
|
This item has no description. | |
|
function From(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Join(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function InnerJoin(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function LeftJoin(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function RightJoin(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function _On(AFilter: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Where(AFilter: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Where_(AFilter: string; AParameters: array of variant): TDBQueryHelper; |
|
This item has no description. | |
|
function _And(AFilter: string): TDBQueryHelper; |
|
This item has no description. | |
|
function _Or(AFilter: string): TDBQueryHelper; |
|
This item has no description. | |
|
function OrderBy(AFields: string): TDBQueryHelper; |
|
This item has no description. | |
|
function OrderBy_(AFields: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function GroupBy(AFields: string): TDBQueryHelper; |
|
This item has no description. | |
|
function GroupBy_(AFields: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function Insert(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Fields(AFields: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Fields_(AFields: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function Values(AValues: array of variant): TDBQueryHelper; |
|
This item has no description. | |
|
function Value(AFieldName: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function Returning(AFields: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Returning_(AFields: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function Return(AField: string): Variant; |
|
This item has no description. | |
|
function Update(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function UpdateOrInsert(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Matching(AFields: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Matching_(AFields: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function Delete(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Parameter(AParameter: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function ClearTableKeyMapping: TDBQueryHelper; |
|
This item has no description. | |
|
function SetupTableKeyMapping(AList: TStrings): TDBQueryHelper; |
|
This item has no description. | |
|
function SetupTableKeyMappingFromString(AList: string): TDBQueryHelper; |
|
This item has no description. | |
|
function SetupTableKeyMappingFromArray(AList: TArrayOfStringPairs): TDBQueryHelper; |
|
This item has no description. | |
|
function Load(ATable: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function LoadID(ATable: string; AField: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function Edit: TDBQueryHelper; |
|
This item has no description. | |
|
function Store: TDBQueryHelper; |
|
This item has no description. | |
|
function New(ATable: string): TDBQueryHelper; |
|
This item has no description. | |
|
function NewID(ATable: string; AField: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Modify(ATable: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function ModifyID(ATable: string; AField: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function ModifyOrNew(ATable: string; AMatching: string): TDBQueryHelper; |
|
This item has no description. | |
|
function ModifyOrNew_(ATable: string; AMatching: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function ModifyOrNewID(ATable: string; AField: string; AMatching: string): TDBQueryHelper; |
|
This item has no description. | |
|
function ModifyOrNewID_(ATable: string; AField: string; AMatching: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function Purge(ATable: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function PurgeID(ATable: string; AField: string; AValue: Variant): TDBQueryHelper; |
|
This item has no description. | |
|
function GetID: Variant; |
|
This item has no description. | |
|
function Execute: TDBQueryHelper; |
|
This item has no description. | |
|
function Dataset: TDataSet; |
|
This item has no description. | |
|
function Clone: TDataSet; |
|
This item has no description. | |
|
function FetchAll(ATable: string; AFields: string; AFilter: string; AOrder: string): TDBQueryHelper; |
|
This item has no description. | |
|
function FetchAll_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant; AOrder: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function Fetch(ATable: string; AFields: string; AFilter: string; AOrder: string): TDBQueryHelper; |
|
This item has no description. | |
|
function Fetch_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant; AOrder: array of string): TDBQueryHelper; |
|
This item has no description. | |
|
function Count(ATable: string; AFields: string; AFilter: string): Variant; |
|
This item has no description. | |
|
function Count_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
This item has no description. | |
|
function Sum(ATable: string; AFields: string; AFilter: string): Variant; |
|
This item has no description. | |
|
function Sum_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
This item has no description. | |
|
function Min(ATable: string; AFields: string; AFilter: string): Variant; |
|
This item has no description. | |
|
function Min_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
This item has no description. | |
|
function Max(ATable: string; AFields: string; AFilter: string): Variant; |
|
This item has no description. | |
|
function Max_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
This item has no description. | |
|
function Avg(ATable: string; AFields: string; AFilter: string): Variant; |
|
This item has no description. | |
|
function Avg_(ATable: string; AFields: array of string; AFilter: string; AParameters: array of variant): Variant; |
|
This item has no description. | |
|
function JumpFirst: TDBQueryHelper; |
|
This item has no description. | |
|
function JumpLast: TDBQueryHelper; |
|
This item has no description. | |
|
function Next: Boolean; |
|
This item has no description. | |
|
function Prior: Boolean; |
|
This item has no description. | |
|
function EOF: Boolean; |
|
This item has no description. | |
|
function BOF: Boolean; |
|
This item has no description. | |
|
function StartTransaction: TDBQueryHelper; |
|
This item has no description. | |
|
function Commit: TDBQueryHelper; |
|
This item has no description. | |
|
function Rollback: TDBQueryHelper; |
|
This item has no description. | |
Tulajdonságok
|
property DateFormat: string; |
|
This item has no description. | |
|
property TimeFormat: string; |
|
This item has no description. | |
|
property DateTimeFormat: string; |
|
This item has no description. | |
|
property _[param1: Variant]: TField; |
|
This item has no description. | |
Készítette PasDoc 0.16.0-snapshot.