TFORMUCTY0"TPF0 TFormUctyFormUctyLeftTopWidthHeightCaptionZobrazeni uctuColor clBtnFace Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.Name MS Sans Serif Font.Style OldCreateOrder PixelsPerInch` TextHeight TPageControl PageControlLeftTopWidthHeight ActivePage TabSheet3AlignalClientTabOrder TTabSheet TabSheet2CaptionVytvoreni uctu ImageIndexTPanelPanel2LeftTopWidthHeightAlignalClientTabOrderTBitBtnBitBtn3LeftTopWidthyHeightCaptionvytvorit klientaTabOrderOnClick BitBtn3ClickTButtonButton1LeftTop8WidthyHeightCaptionstavajici klientTabOrderOnClick Button1ClickTDBGridDBGrid1LeftTop`Width9Heighti DataSourceDataSourceNameOptions dgEditingdgTitles dgIndicator dgColLines dgRowLinesdgTabsdgConfirmDeletedgCancelOnExitTabOrderTitleFont.CharsetDEFAULT_CHARSETTitleFont.Color clWindowTextTitleFont.HeightTitleFont.Name MS Sans SerifTitleFont.Style ColumnsExpanded FieldNameprijmeniWidthTVisible Expanded FieldNamejmenoVisible Expanded FieldNamercVisible TButtonButton2LeftTop8WidthHeightCaption Zmena uctuTabOrderOnClick Button2Click TGroupBox GroupBox5LeftPTopWidthQHeightQCaptionInformace o uctuTabOrderTLabelLabel20LeftTopWidth.Height Caption Cislo uctuTButtonButton6LeftTopWidthYHeightCaption GenerovatTabOrderOnClickGen_cuctuClick TGroupBox GroupBoxKartaLeftTopWidth9HeightQCaptionKartaEnabledTabOrderTLabelLabel21LeftTopWidth0Height Caption Cislo kartyTLabelLabel1LeftTop0Width&Height CaptionPlatnostTButton ButtonCKartyLeftTopWidthYHeightCaption GenerovatTabOrderOnClickButtonCKartyClickTEdit Karta_cisloLeft@TopWidthyHeightTabOrderTEditkarta_platnostLeft@Top0WidthyHeightTabOrder TCheckBox CheckKartaLeftTopWidthaHeightCaptionVytvorit kartuTabOrderOnClickCheckKartaClick TGroupBox GroupBox7LeftTopWidth9HeightaCaptionInformace o klientoviTabOrderTLabel klient_rcLeftxTopPWidth Height CaptionrcTLabel klient_adresaLeftxTop@Width Height CaptionadresaTLabelklient_prijmeniLeftxTop0Width#Height CaptionprijmeniTLabel klient_jmenoLeftxTop WidthHeight CaptionjmenoTLabel klient_idLeftxTopWidthHeight CaptionidTLabelLabel27LeftTopWidth[Height CaptionOsobni cislo klientaTLabelLabel28LeftTop WidthHeight CaptionJmenoTLabelLabel29LeftTop0Width$Height CaptionPrijmeniTLabelLabel30LeftTop@Width!Height CaptionAdresaTLabelLabel31LeftTopPWidth8Height Caption Rodne cisloTBitBtnBitBtn1LeftTop(WidthHeightTabOrderOnClick BitBtn1ClickKindbkOKTBitBtnBitBtn2LeftTop(WidthHeightCaptionZrusitTabOrderOnClick BitBtn2ClickKindbkAbortTEdit Ucet_cisloLeftPTopWidthyHeightTabOrder TTabSheet TabSheet1CaptionUctyTDBGrid DBGridUcetLeftTopWidthHeight DataSource DataSourceTabOrderTitleFont.CharsetDEFAULT_CHARSETTitleFont.Color clWindowTextTitleFont.HeightTitleFont.Name MS Sans SerifTitleFont.Style TBitBtn btnUpdateLeftTopWidthKHeightCaptionZobrazitTabOrderOnClickbtnUpdateClickTEditdotazLeft`TopWidth9HeightTabOrder TRadioGroup RadioGroup1LeftTop(WidthHeightCaption VyhledavaniTabOrder TRadioButtonRadioButtonKlientLeftTop@WidthHeightCaptionTransakce podle klientaChecked TabOrderTabStop TPanelPanel1LeftTop8WidthHeight!TabOrderTLabelLabel7LeftTopWidthHeight CaptionJmenoTLabelLabel8LeftTopWidth$Height CaptionPrijmeniTEdit EditSrchJmenoLeft@TopWidthHeightTabOrderTEditEditSrchPrijmeniLeft TopWidthHeightTabOrder TRadioButtonRadioButtonBankLeftTophWidthHeightCaptionTransakce - BankomatTabOrder TRadioButtonRadioButtonPrepLeftTopWidthHeightCaptionTransakce - PrepazkaTabOrder TTabSheet TabSheet3CaptionProvest transakci ImageIndex TGroupBox GroupBox1LeftTopWidthHeightCaption Kdo platiTabOrderTLabelLabelTypLeftTopPWidth.Height Caption Cislo uctuTDBGridDBGrid2Left TopWidthHeightq DataSourceDataSourceTransakceTabOrderTitleFont.CharsetDEFAULT_CHARSETTitleFont.Color clWindowTextTitleFont.HeightTitleFont.Name MS Sans SerifTitleFont.Style OnCellClickDBGrid2CellClick TRadioGroup TypTransakceLeftTopWidth Height)Caption TypTransakceTabOrder TRadioButton RadioButton1LeftTop WidthqHeightCaptionTransakce UctemChecked TabOrderTabStop OnClickRadioButton1Click TRadioButton RadioButton2LeftTop WidthqHeightCaptionTransakce KartouTabOrderOnClickRadioButton2ClickTEdit EditcisloLefthTopPWidthHeightTabOrderTButton ButtonFindLeftToppWidthKHeightCaptionVyhledatTabOrderOnClickButtonFindClick TGroupBox GroupBox2LeftTopWidthHeightCaption Kde platiTabOrderTLabelLabel2LeftTopWidthHeight CaptionJmenoTLabelLabel3LeftTopWidth$Height CaptionPrijmeniTLabelLabel4Left`TopWidth*Height CaptionZustatekTLabelLabelkjLeft8TopWidth]HeightCaption jmeno klienta Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.Name MS Sans Serif Font.Style fsBold ParentFontTLabelLabelkpLeftTopWidthjHeightCaptionprijmeni klienta Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.Name MS Sans Serif Font.Style fsBold ParentFontTLabel LabelzustLeftTopWidth:HeightCaptionzustatek Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.Name MS Sans Serif Font.Style fsBold ParentFontTLabel LabelInfoLeftTopWidth[Height Captioninformacni okno Font.CharsetDEFAULT_CHARSET Font.ColorclRed Font.Height Font.Name MS Sans Serif Font.Pitch fpVariable Font.Style fsBold ParentFont TGroupBox GroupBoxUctemLeftTop0WidthAHeightyCaption GroupBoxUctemTabOrderTLabelLabel5LeftTop0Width?Height Caption Hodnota (Kc) TComboBox ComboBoxAkceLeftTopWidthqHeight ItemHeight Items.StringsVklad na prepazceVyber na prepazceTabOrderTEdit EditHodnotaLeftPTop0WidthHeightTabOrder TComboBoxComboBoxAdresaLeftTopWidthHeight ItemHeight Items.StringsCP, Skolsska 17CP, Frantiskova 13TabOrderTBitBtnBitBtn4LeftTopPWidthKHeightTabOrderOnClick BitBtn4ClickKindbkOKTBitBtnBitBtn5LeftTopPWidthKHeightTabOrderKindbkAbort TGroupBoxGroupBoxKartouLeftXTop0Width1HeightyCaptionGroupBoxKartouTabOrderTLabelLabel6LeftTop8Width?Height Caption Hodnota (Kc) TComboBox ComboBoxKTypLeftTopWidthHeight ItemHeight Items.Strings Platba kartou Vyber z KartyTabOrder TComboBoxComboBoxKAdresaLeftTopWidthHeight ItemHeight Items.Strings Tesco, ZlicinBankomat DejvickaTabOrderTEdit EditKHodnotaLeftTop8WidthHeightTabOrderTBitBtnBitBtn6LeftTopXWidthKHeightTabOrderOnClick BitBtn6ClickKindbkOKTBitBtnBitBtn7LefthTopXWidthKHeightTabOrderKindbkAbort TDatabaseDatabase AliasNameSTORES7 Connected DatabaseNamebanka LoginPromptParams.StringsUSER NAME=studpis password=data SessionNameDefaultLeftKTop TDataSource DataSourceDataSet QueryKlientLeft+TopTQuery QueryKlientActive DatabaseNamebanka SessionNameDefault SQL.Strings{select*from  terminal}{where}{ u.klient_id=k.klient_id,}{ u.karta_id=ka.karta_id}Q{select * from klient k, ucet u where k.jmeno='Jiri' and u.klient_id=k.klient_id}select * from terminalLeft TopTQuery QueryName DatabaseNamebanka SQL.Stringsselect *from klientorder by prijmeni, jmenoLeftTop TDataSourceDataSourceNameDataSet QueryNameLeftlTopTTable TableZmeny DatabaseNamebanka TableNamekkartaLeftTTopq TDataSourceDataSourceNewUcetDataSet TableZmenyLefttTopqTQueryNUQueryActive DatabaseNamebanka SQL.Strings#SELECT max(ucet_id) as ID FROM ucetLeft4TopqTQueryQueryTransakceActive DatabaseNamebanka SQL.Strings%select cislo_uctu as cislo from ucetLeftTopy TDataSourceDataSourceTransakceDataSetQueryTransakceLeftTopTQueryQueryTransakce2 DatabaseNamebankaLeftTop