TZUpdateSQLEditForm Class Reference

Inheritance diagram for TZUpdateSQLEditForm:

TForm

List of all members.

Public Member Functions

 ClearAllClick (TObject Sender)
 DefaultButtonClick (TObject Sender)
 FormCloseQuery (TObject Sender, Boolean &CanClose)
 FormCreate (TObject Sender)
 FormDestroy (TObject Sender)
 GenerateButtonClick (TObject Sender)
 GetTableFieldsButtonClick (TObject Sender)
 HelpButtonClick (TObject Sender)
 OkButtonClick (TObject Sender)
 PageControlChanging (TObject Sender, Boolean &AllowChange)
 PrimaryKeyButtonClick (TObject Sender)
 SelectAllClick (TObject Sender)
 SettingsChanged (TObject Sender)
 SQLMemoKeyPress (TObject Sender, Char &Key)
 StatementTypeClick (TObject Sender)
 UpdateTableNameChange (TObject Sender)
 UpdateTableNameClick (TObject Sender)

Public Attributes

TButton CancelButton
TButton DefaultButton
TPopupMenu FieldListPopup
TTabSheet FieldsPage
TButton GenerateButton
TButton GetTableFieldsButton
TGroupBox GroupBox1
TButton HelpButton
TListBox KeyFieldList
TLabel Label1
TLabel Label2
TLabel Label3
TLabel Label4
TMenuItem miClearAll
TMenuItem miSelectAll
TButton OkButton
TPageControl PageControl
TButton PrimaryKeyButton
TCheckBox QuoteFields
TMemo SQLMemo
TTabSheet SQLPage
TRadioGroup StatementType
TListBox UpdateFieldList
TComboBox UpdateTableName

Private Member Functions

Boolean Edit ()
 GenDeleteSQL (const string TableName, TStrings KeyFields, TStrings SQL)
 GenerateSQL ()
 GenInsertSQL (const string TableName, TStrings UpdateFields, TStrings SQL)
 GenModifySQL (const string TableName, TStrings KeyFields, TStrings UpdateFields, TStrings SQL)
 GenWhereClause (const string TabAlias, TStrings KeyFields, TStrings SQL)
 GetDataSetFieldNames ()
 GetTableFieldNames ()
string GetTableRef (const string TabName)
 InitGenerateOptions ()
 InitUpdateTableNames ()
 SelectPrimaryKeyFields ()
 SetButtonStates ()
 SetDefaultSelections ()
 ShowWait (TWaitMethod WaitMethod)

Private Attributes

Boolean ConnectionOpened
TZAbstractDataset DataSet
Boolean FDatasetDefaults
Boolean FSettingsChanged
string QuoteChar
TStrings SQLText [999]
Integer StmtIndex
TZUpdateSQL UpdateSQL


Detailed Description

Definition at line 99 of file ZUpdateSqlEditor.pas.


Member Function Documentation

TZUpdateSQLEditForm::ClearAllClick ( TObject  Sender  ) 

TZUpdateSQLEditForm::DefaultButtonClick ( TObject  Sender  ) 

Boolean TZUpdateSQLEditForm::Edit (  )  [private]

TZUpdateSQLEditForm::FormCloseQuery ( TObject  Sender,
Boolean &  CanClose 
)

TZUpdateSQLEditForm::FormCreate ( TObject  Sender  ) 

TZUpdateSQLEditForm::FormDestroy ( TObject  Sender  ) 

TZUpdateSQLEditForm::GenDeleteSQL ( const string  TableName,
TStrings  KeyFields,
TStrings  SQL 
) [private]

Definition at line 975 of file ZUpdateSqlEditor.pas.

TZUpdateSQLEditForm::GenerateButtonClick ( TObject  Sender  ) 

TZUpdateSQLEditForm::GenerateSQL (  )  [private]

TZUpdateSQLEditForm::GenInsertSQL ( const string  TableName,
TStrings  UpdateFields,
TStrings  SQL 
) [private]

TZUpdateSQLEditForm::GenModifySQL ( const string  TableName,
TStrings  KeyFields,
TStrings  UpdateFields,
TStrings  SQL 
) [private]

Definition at line 1033 of file ZUpdateSqlEditor.pas.

TZUpdateSQLEditForm::GenWhereClause ( const string  TabAlias,
TStrings  KeyFields,
TStrings  SQL 
) [private]

Definition at line 940 of file ZUpdateSqlEditor.pas.

TZUpdateSQLEditForm::GetDataSetFieldNames (  )  [private]

Definition at line 1127 of file ZUpdateSqlEditor.pas.

TZUpdateSQLEditForm::GetTableFieldNames (  )  [private]

Definition at line 1137 of file ZUpdateSqlEditor.pas.

TZUpdateSQLEditForm::GetTableFieldsButtonClick ( TObject  Sender  ) 

string TZUpdateSQLEditForm::GetTableRef ( const string  TabName  )  [private]

Definition at line 1162 of file ZUpdateSqlEditor.pas.

TZUpdateSQLEditForm::HelpButtonClick ( TObject  Sender  ) 

TZUpdateSQLEditForm::InitGenerateOptions (  )  [private]

TZUpdateSQLEditForm::InitUpdateTableNames (  )  [private]

TZUpdateSQLEditForm::OkButtonClick ( TObject  Sender  ) 

TZUpdateSQLEditForm::PageControlChanging ( TObject  Sender,
Boolean &  AllowChange 
)

TZUpdateSQLEditForm::PrimaryKeyButtonClick ( TObject  Sender  ) 

TZUpdateSQLEditForm::SelectAllClick ( TObject  Sender  ) 

TZUpdateSQLEditForm::SelectPrimaryKeyFields (  )  [private]

TZUpdateSQLEditForm::SetButtonStates (  )  [private]

TZUpdateSQLEditForm::SetDefaultSelections (  )  [private]

TZUpdateSQLEditForm::SettingsChanged ( TObject  Sender  ) 

TZUpdateSQLEditForm::ShowWait ( TWaitMethod  WaitMethod  )  [private]

TZUpdateSQLEditForm::SQLMemoKeyPress ( TObject  Sender,
Char &  Key 
)

TZUpdateSQLEditForm::StatementTypeClick ( TObject  Sender  ) 

TZUpdateSQLEditForm::UpdateTableNameChange ( TObject  Sender  ) 

TZUpdateSQLEditForm::UpdateTableNameClick ( TObject  Sender  ) 


Member Data Documentation

Definition at line 111 of file ZUpdateSqlEditor.pas.

Definition at line 229 of file ZUpdateSqlEditor.pas.

Definition at line 225 of file ZUpdateSqlEditor.pas.

Definition at line 119 of file ZUpdateSqlEditor.pas.

Definition at line 235 of file ZUpdateSqlEditor.pas.

Definition at line 145 of file ZUpdateSqlEditor.pas.

Definition at line 123 of file ZUpdateSqlEditor.pas.

Definition at line 233 of file ZUpdateSqlEditor.pas.

Definition at line 115 of file ZUpdateSqlEditor.pas.

Definition at line 143 of file ZUpdateSqlEditor.pas.

Definition at line 133 of file ZUpdateSqlEditor.pas.

Definition at line 113 of file ZUpdateSqlEditor.pas.

Definition at line 129 of file ZUpdateSqlEditor.pas.

Definition at line 135 of file ZUpdateSqlEditor.pas.

Definition at line 103 of file ZUpdateSqlEditor.pas.

Definition at line 105 of file ZUpdateSqlEditor.pas.

Definition at line 107 of file ZUpdateSqlEditor.pas.

Definition at line 149 of file ZUpdateSqlEditor.pas.

Definition at line 147 of file ZUpdateSqlEditor.pas.

Definition at line 109 of file ZUpdateSqlEditor.pas.

Definition at line 127 of file ZUpdateSqlEditor.pas.

Definition at line 117 of file ZUpdateSqlEditor.pas.

Definition at line 227 of file ZUpdateSqlEditor.pas.

Definition at line 141 of file ZUpdateSqlEditor.pas.

Definition at line 137 of file ZUpdateSqlEditor.pas.

Definition at line 125 of file ZUpdateSqlEditor.pas.

TStrings TZUpdateSQLEditForm::SQLText[999] [private]

[999]

Definition at line 237 of file ZUpdateSqlEditor.pas.

Definition at line 139 of file ZUpdateSqlEditor.pas.

Integer TZUpdateSQLEditForm::StmtIndex [private]

Definition at line 223 of file ZUpdateSqlEditor.pas.

Definition at line 131 of file ZUpdateSqlEditor.pas.

Definition at line 231 of file ZUpdateSqlEditor.pas.

Definition at line 121 of file ZUpdateSqlEditor.pas.


The documentation for this class was generated from the following file:

Generated on Wed Dec 30 08:42:58 2009 for zeoslib by  doxygen 1.5.7.1