Unit StdComps

Classes

TAbout - TAbout
TAboutBox - TAboutBox
TAboutProperty - TAbout Property
TComponentButton - TComponentButton
TFormSelJoins - TFormSelJoins
TJoins - TJoins
TJoinsProperty - TJoinsProperty

Functions

getDelimeted - returns the from part of an SQl statement if the dataset is a query, or the table name if the dataset is a table.
GetFields - Returns the line and position of the word Str in S returns zero if not found

Returns the line and position of the word Str in S returns zero if not found
GetSQLClause - returns the fields in a stringlist

returns the fields in a stringlist
GetStrPos - Public Methods
Register - Returns the items in the string list as a string

Types

TSQLClause

Constants

Variables


Functions


function getDelimeted(SL:TStringList):String;

returns the from part of an SQl statement if the dataset is a query, or the table name if the dataset is a table. Queries must be in the form: Select from where order by and are optional

TQuery


procedure GetFields(DS: TDataSet; var Fields: TStringList);

Returns the line and position of the word Str in S returns zero if not found

Returns the line and position of the word Str in S returns zero if not found


procedure GetSQLClause(DS: TDataset; ClauseType: TSQLClause; var Clause: TStringList);

returns the fields in a stringlist

returns the fields in a stringlist


procedure GetStrPos(S: TStringList; Str: String; var StrLine, StrPos: Integer);

Public Methods

procedure Register;

Returns the items in the string list as a string

Types


TSQLClause = (sqlFields, sqlTables, sqlWhere, sqlOrder);
SQl functions

Constants


Variables