home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.sanbilgisayar.com
/
ftp.sanbilgisayar.com.tar
/
ftp.sanbilgisayar.com
/
SHOP
/
ShopImportP.exe
/
0
/
RCDATA
/
TDMREHBER
/
TDMREHBER.txt
Wrap
Text File
|
2015-03-03
|
9KB
|
338 lines
object DMrehber: TDMrehber
OldCreateOrder = True
OnCreate = DMCreate
OnDestroy = DataModuleDestroy
Left = 272
Top = 160
Height = 270
Width = 329
object RehberTmp: TMSQuery
Connection = mDM.MSConnection
SQL.Strings = (
'Select * From Rehber'
'Order By Kodu')
Left = 249
Top = 23
end
object Rehber_DS: TDataSource
DataSet = Rehber
Left = 20
Top = 2
end
object Rehber: TMSQuery
SQLInsert.Strings = (
'insert into Rehber'
' (Kodu, Adi, Aciklama, Resim, Bastarih, Ciktarih, DTarih, Tahsi' +
'l, BelgeNo, Tel, EvTel, CepTel, Cinsiyet, Adres1, Adres2, Adres3' +
', Almanca, Ingilizce, Fransizca, Rusca, Flemence, Italyanca, Tur' +
'kce, Azerice, Fince, Lehce, KomIpt, AyCalGunu, AyUcret, AyUcretD' +
'ov,Ibranice,Arabca,DigDil,RehTipi)'
'values'
' (:Kodu, :Adi, :Aciklama, :Resim, :Bastarih, :Ciktarih, :DTarih' +
', :Tahsil, :BelgeNo, :Tel, :EvTel, :CepTel, :Cinsiyet, :Adres1, ' +
':Adres2, :Adres3, :Almanca, :Ingilizce, :Fransizca, :Rusca, :Fle' +
'mence, :Italyanca, :Turkce, :Azerice, :Fince, :Lehce, :KomIpt, :' +
'AyCalGunu, :AyUcret, :AyUcretDov,:Ibranice,:Arabca,:DigDil,:RehT' +
'ipi)')
SQLDelete.Strings = (
'delete from Rehber'
'where'
' Kodu = :OLD_Kodu')
SQLUpdate.Strings = (
'update Rehber'
'set'
' Kodu = :Kodu,'
' Adi = :Adi,'
' Aciklama = :Aciklama,'
' Resim = :Resim,'
' Bastarih = :Bastarih,'
' Ciktarih = :Ciktarih,'
' DTarih = :DTarih,'
' Tahsil = :Tahsil,'
' BelgeNo = :BelgeNo,'
' Tel = :Tel,'
' EvTel = :EvTel,'
' CepTel = :CepTel,'
' Cinsiyet = :Cinsiyet,'
' Adres1 = :Adres1,'
' Adres2 = :Adres2,'
' Adres3 = :Adres3,'
' Almanca = :Almanca,'
' Ingilizce = :Ingilizce,'
' Fransizca = :Fransizca,'
' Rusca = :Rusca,'
' Flemence = :Flemence,'
' Italyanca = :Italyanca,'
' Turkce = :Turkce,'
' Azerice = :Azerice,'
' Fince = :Fince,'
' Lehce = :Lehce,'
' KomIpt = :KomIpt,'
' AyCalGunu = :AyCalGunu,'
' AyUcret = :AyUcret,'
' AyUcretDov = :AyUcretDov,'
' Ibranice = :Ibranice,'
' Arabca = :Arabca,'
' DigDil = :DigDil,'
' RehTipi = :RehTipi'
'where'
' Kodu = :OLD_Kodu')
Connection = mDM.MSConnection
SQL.Strings = (
'Select * From Rehber with (NOLOCK)'
'Order By Kodu')
BeforeInsert = RehberBeforeInsert
BeforeEdit = RehberBeforeEdit
BeforePost = RehberBeforePost
BeforeDelete = RehberBeforeDelete
OnDeleteError = UpdateError
OnEditError = UpdateError
OnPostError = UpdateError
Left = 20
Top = 48
object RehberKodu: TStringField
DisplayLabel = 'Kodu '
DisplayWidth = 8
FieldName = 'Kodu'
Origin = 'Rehber.Kodu'
Size = 6
end
object RehberAdi: TStringField
DisplayLabel = 'Ad'#305
DisplayWidth = 27
FieldName = 'Adi'
Origin = 'Rehber.Adi'
Size = 25
end
object RehberAciklama: TStringField
DisplayLabel = 'A'#231#305'klama'
DisplayWidth = 40
FieldName = 'Aciklama'
Origin = 'Rehber.Aciklama'
Size = 80
end
object RehberRehTipi: TStringField
FieldName = 'RehTipi'
Size = 6
end
object RehberRehTipiTanim: TStringField
DisplayLabel = 'Rehber Tipi'
DisplayWidth = 28
FieldKind = fkLookup
FieldName = 'RehTipiTanim'
LookupDataSet = RehTipi
LookupKeyFields = 'Kod'
LookupResultField = 'Tanim'
KeyFields = 'RehTipi'
Size = 25
Lookup = True
end
object RehberResim: TStringField
DisplayLabel = 'Resim '
FieldName = 'Resim'
Origin = 'Rehber.Resim'
Size = 15
end
object RehberBastarih: TDateTimeField
DisplayLabel = 'Ba'#351'lama Tarihi'
DisplayWidth = 10
FieldName = 'Bastarih'
Origin = 'Rehber.Bastarih'
OnSetText = TarihSetText
DisplayFormat = 'dd/mm/yyyy'
EditMask = '99/99/9999'
end
object RehberCiktarih: TDateTimeField
FieldName = 'Ciktarih'
Origin = 'Rehber.Ciktarih'
EditMask = '99/99/9999'
end
object RehberDTarih: TDateTimeField
DisplayLabel = 'Do'#287'um Tarihi'
DisplayWidth = 10
FieldName = 'DTarih'
Origin = 'Rehber.DTarih'
DisplayFormat = 'dd/mm/yyyy'
EditMask = '99/99/9999'
end
object RehberTahsil: TStringField
DisplayLabel = 'Tahsili'
FieldName = 'Tahsil'
Origin = 'Rehber.Tahsil'
Size = 10
end
object RehberBelgeNo: TStringField
DisplayLabel = 'Belge No'
DisplayWidth = 10
FieldName = 'BelgeNo'
Origin = 'Rehber.BelgeNo'
Size = 15
end
object RehberTel: TStringField
DisplayLabel = 'Tel '
DisplayWidth = 11
FieldName = 'Tel'
Origin = 'Rehber.Tel'
Size = 15
end
object RehberEvTel: TStringField
DisplayLabel = 'Ev Tel'
DisplayWidth = 11
FieldName = 'EvTel'
Origin = 'Rehber.EvTel'
Size = 15
end
object RehberCepTel: TStringField
DisplayLabel = 'Cep Tel'
DisplayWidth = 11
FieldName = 'CepTel'
Origin = 'Rehber.CepTel'
Size = 15
end
object RehberCinsiyet: TStringField
DisplayLabel = 'Cinsiyet '
DisplayWidth = 8
FieldName = 'Cinsiyet'
Origin = 'Rehber.Cinsiyet'
Size = 5
end
object RehberAdres1: TStringField
FieldName = 'Adres1'
Origin = 'Rehber.Adres1'
Size = 30
end
object RehberAdres2: TStringField
FieldName = 'Adres2'
Origin = 'Rehber.Adres2'
Size = 30
end
object RehberAdres3: TStringField
FieldName = 'Adres3'
Origin = 'Rehber.Adres3'
Size = 30
end
object RehberKomIpt: TStringField
FieldName = 'KomIpt'
Origin = 'Rehber.KomIpt'
Size = 1
end
object RehberAlmanca: TStringField
FieldName = 'Almanca'
Origin = 'Rehber.Almanca'
Size = 1
end
object RehberIngilizce: TStringField
FieldName = 'Ingilizce'
Origin = 'Rehber.Ingilizce'
Size = 1
end
object RehberFransizca: TStringField
FieldName = 'Fransizca'
Origin = 'Rehber.Fransizca'
Size = 1
end
object RehberRusca: TStringField
FieldName = 'Rusca'
Origin = 'Rehber.Rusca'
Size = 1
end
object RehberFlemence: TStringField
FieldName = 'Flemence'
Origin = 'Rehber.Flemence'
Size = 1
end
object RehberItalyanca: TStringField
FieldName = 'Italyanca'
Origin = 'Rehber.Italyanca'
Size = 1
end
object RehberTurkce: TStringField
FieldName = 'Turkce'
Origin = 'Rehber.Turkce'
Size = 1
end
object RehberAzerice: TStringField
FieldName = 'Azerice'
Origin = 'Rehber.Azerice'
Size = 1
end
object RehberFince: TStringField
FieldName = 'Fince'
Origin = 'Rehber.Fince'
Size = 1
end
object RehberLehce: TStringField
FieldName = 'Lehce'
Origin = 'Rehber.Lehce'
Size = 1
end
object RehberAyCalGunu: TSmallintField
FieldName = 'AyCalGunu'
Origin = 'Rehber.AyCalGunu'
end
object RehberAyUcret: TFloatField
FieldName = 'AyUcret'
Origin = 'Rehber.AyUcret'
end
object RehberAyUcretDov: TStringField
FieldName = 'AyUcretDov'
Origin = 'Rehber.AyUcretDov'
Size = 3
end
object RehberIbranice: TStringField
FieldName = 'Ibranice'
Origin = 'Rehber.Ibranice'
Size = 1
end
object RehberArabca: TStringField
FieldName = 'Arabca'
Origin = 'Rehber.Arabca'
Size = 1
end
object RehberDigDil: TStringField
FieldName = 'DigDil'
Origin = 'Rehber.DigDil'
Size = 50
end
end
object DovCins: TMSQuery
Connection = mDM.MSConnection
SQL.Strings = (
'Select * From DovCins')
Left = 165
Top = 50
end
object DovCins_DS: TDataSource
DataSet = DovCins
Left = 167
Top = 4
end
object RehTipiDS: TDataSource
DataSet = RehTipi
Left = 24
Top = 104
end
object RehTipi: TMSQuery
Connection = mDM.MSConnection
SQL.Strings = (
'Select * from RehTipi')
Left = 24
Top = 160
object RehTipiKod: TStringField
FieldName = 'Kod'
Size = 6
end
object RehTipiTanim: TStringField
FieldName = 'Tanim'
Size = 25
end
end
object TempQry: TMSQuery
Connection = mDM.MSConnection
Left = 209
Top = 143
end
end