<?xml version="1.0" encoding="iso-8859-9" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>Clomosy | Forum : tarih sorunu</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : tarih sorunu]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 14:37:26 +0000</pubDate>
  <lastBuildDate>Wed, 16 Jul 2025 12:16:35 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.07</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://forum.clomosy.com.tr/RSS_post_feed.asp?TID=1092</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Clomosy | Forum]]></title>
   <url>https://forum.clomosy.com.tr/forum_images/logo.png</url>
   <link>https://forum.clomosy.com.tr/</link>
  </image>
  <item>
   <title><![CDATA[tarih sorunu : Merhaba Muammer sorun ba&#351;lang&#305;&#231;...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1092&amp;PID=2224#2224</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=306">cerenn</a><br /><strong>Konu:</strong> 1092<br /><strong>Gönderim Zamanı:</strong> 16&nbsp;Temmuz&nbsp;2025 Saat 12:16<br /><br />Merhaba Muammer sorun başlangıç değeri vermemenden kaynaklı olabilir.&nbsp;<div><span ="token maybe--name">DtEdt1</span><span ="token" style="color: rgb56, 58, 66;">.</span><span ="token known--name" style="">Date</span> <span ="token" style="">=</span> <span ="token maybe--name" style="">Now</span><span ="token" style="color: rgb56, 58, 66;">(</span><span ="token" style="color: rgb56, 58, 66;">)</span><span ="token" style="color: rgb56, 58, 66;">;</span>&nbsp;</div><div>ya da&nbsp;<span ="token" style="color: rgb160, 161, 167; font-style: italic;">&nbsp;</span><span ="token" style="font-style: italic;">özel format istiyorsan</span></div><div>&nbsp; <span ="token maybe--name">DtEdt1</span><span ="token" style="color: rgb56, 58, 66;">.</span><span ="token property-access maybe--name">DateStr</span> <span ="token" style="color: rgb64, 120, 242;">=</span> <span ="token maybe--name" style="">FormatDateTime</span><span ="token" style="">(</span><span ="token" style="">'dd.mm.yyyy'</span><span ="token" style="">,</span> <span ="token maybe--name" style="">Now</span><span ="token" style="">(</span><span ="token" style="">)</span><span ="token" style="">)</span><span ="token" style="">;&nbsp;&nbsp;</span></div><div><span ="token" style="">şeklinde dener misin formu oluşturduğunda</span></div><div><span ="token" style="">İyi çalışmalar</span></div>]]>
   </description>
   <pubDate>Wed, 16 Jul 2025 12:16:35 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1092&amp;PID=2224#2224</guid>
  </item> 
  <item>
   <title><![CDATA[tarih sorunu : A&#351;a&#287;&#305;da &#252;r&#252;n ekle sayfas&#305;n&#305;n kodu...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1092&amp;PID=2221#2221</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=309">Muammer</a><br /><strong>Konu:</strong> 1092<br /><strong>Gönderim Zamanı:</strong> 16&nbsp;Temmuz&nbsp;2025 Saat 12:04<br /><br />Aşağıda ürün ekle sayfasının kodu var.Bu kodda tarihi güncel olarak algılamıyor ve 01.01.1900 olarak yazıyor.<br><br><div>var</div><div>&nbsp; MyForm: TclForm;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</div><div>&nbsp; MyGrid: TclStringGrid;&nbsp; &nbsp;&nbsp;</div><div>&nbsp; Lbl_Baslik: TClProLabel;&nbsp;&nbsp;</div><div>&nbsp; DtEdt1: TClProDateEdit;&nbsp; &nbsp;</div><div>&nbsp; Edt_StokKodu, Edt_UrunAdi, Edt_StokMiktari, Edt_DepoYeriID, Edt_BirimFiyat: TclProEdit;&nbsp;</div><div>&nbsp; Lbl_Tarih, Lbl_UrunAdi, Lbl_StokMiktari: TClProLabel;&nbsp; &nbsp;</div><div>&nbsp; Lbl_StokKodu: TClProLabel;</div><div>&nbsp; Lbl_DepoYeriID, Lbl_BirimFiyat: TClProLabel;&nbsp;</div><div>&nbsp; Btn_YeniUrunEkle: TClProButton;</div><div>&nbsp; selectQuery: TClSqlQuery;</div><div>&nbsp; mainPnl, leftPanel, rightPanel: TclProPanel;&nbsp;&nbsp;</div><div><br></div><div>// Grid Kolonları Ayarla</div><div>void SetupGridColumns</div><div>{</div><div>&nbsp; MyGrid.Columns&#091;0&#093;.Header = 'Ürün Kodu';</div><div>&nbsp; MyGrid.Columns&#091;1&#093;.Header = 'Ürün Adı';</div><div>&nbsp; MyGrid.Columns&#091;2&#093;.Header = 'Stok Miktarı';</div><div>&nbsp; MyGrid.Columns&#091;3&#093;.Header = 'Kritik Seviye';</div><div>&nbsp; MyGrid.Columns&#091;4&#093;.Header = 'Depo Yeri ID';</div><div>&nbsp; MyGrid.Columns&#091;5&#093;.Header = 'Birim Fiyat';</div><div>&nbsp; MyGrid.Columns&#091;6&#093;.Header = 'Tarih';</div><div><br></div><div>&nbsp; MyGrid.Columns&#091;0&#093;.Width = 150;</div><div>&nbsp; MyGrid.Columns&#091;1&#093;.Width = 120;</div><div>&nbsp; MyGrid.Columns&#091;2&#093;.Width = 150;</div><div>&nbsp; MyGrid.Columns&#091;3&#093;.Width = 120;</div><div>&nbsp; MyGrid.Columns&#091;4&#093;.Width = 120;</div><div>&nbsp; MyGrid.Columns&#091;5&#093;.Width = 120;</div><div>}</div><div><br></div><div>// Grid Veri Ekle</div><div>void AddDataToGrid</div><div>{</div><div>&nbsp; try</div><div>&nbsp; &nbsp; selectQuery.SQL.Text = 'SELECT UrunKodu, UrunAdi, StokMiktari, KritikSeviye, DepoYeriID, BirimFiyat, OlusturmaTarihi FROM TBLSTOKSB';</div><div>&nbsp; &nbsp; selectQuery.Open;</div><div><br></div><div>&nbsp; &nbsp; if (selectQuery.Found)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; MyForm.RemoveGridBinding('myLink');</div><div>&nbsp; &nbsp; &nbsp; MyForm.AddNewGridBinding(MyGrid, selectQuery, 'myLink');</div><div>&nbsp; &nbsp; &nbsp; SetupGridColumns;</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kayıt bulunamadı!');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; except</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Hata oluştu: ' + LastExceptionMessage);</div><div>&nbsp; }</div><div>&nbsp; }</div><div>}</div><div><br></div><div>// Ürün Ekle Butonu</div><div>void EkleButtonClick</div><div>{</div><div>&nbsp; if ((Edt_StokKodu.Text == '') || (Edt_UrunAdi.Text == '') || (Edt_StokMiktari.Text == '') ||</div><div>&nbsp; &nbsp; &nbsp; (DtEdt1.DateStr == '') || (Edt_DepoYeriID.Text == '') || (Edt_BirimFiyat.Text == ''))</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Lütfen tüm alanları doldurun.');</div><div>&nbsp; }</div><div>&nbsp; else</div><div>&nbsp; {</div><div>&nbsp; &nbsp; try</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; selectQuery.SQL.Text = 'SELECT UrunKodu FROM TBLSTOKSB WHERE UrunKodu = ' + QuotedStr(Edt_StokKodu.Text);</div><div>&nbsp; &nbsp; &nbsp; selectQuery.Open;</div><div><br></div><div>&nbsp; &nbsp; &nbsp; if (selectQuery.Found)</div><div>&nbsp; &nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; &nbsp; selectQuery.SQL.Text =</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'UPDATE TBLSTOKSB SET UrunAdi = ' + QuotedStr(Edt_UrunAdi.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'StokMiktari = StokMiktari + ' + Edt_StokMiktari.Text + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'OlusturmaTarihi = ' + QuotedStr(DtEdt1.DateStr) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DepoYeriID = ' + QuotedStr(Edt_DepoYeriID.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BirimFiyat = ' + QuotedStr(Edt_BirimFiyat.Text) + ' ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'WHERE UrunKodu = ' + QuotedStr(Edt_StokKodu.Text);</div><div>&nbsp; &nbsp; &nbsp; &nbsp; selectQuery.ExecSQL;</div><div>&nbsp; &nbsp; &nbsp; &nbsp; ShowMessage('Ürün bilgisi güncellendi.');</div><div>&nbsp; &nbsp; &nbsp; }</div><div>&nbsp; &nbsp; &nbsp; else</div><div>&nbsp; &nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; &nbsp; selectQuery.SQL.Text =</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'INSERT INTO TBLSTOKSB (UrunKodu, UrunAdi, StokMiktari, OlusturmaTarihi, KritikSeviye, DepoYeriID, BirimFiyat) VALUES (' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QuotedStr(Edt_StokKodu.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QuotedStr(Edt_UrunAdi.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Edt_StokMiktari.Text + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'TRY_CONVERT(DATE, ' + QuotedStr(DtEdt1.DateStr) + ', 104), ' +&nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '0, ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QuotedStr(Edt_DepoYeriID.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QuotedStr(Edt_BirimFiyat.Text) + ')';</div><div>&nbsp; &nbsp; &nbsp; &nbsp; selectQuery.ExecSQL;</div><div>&nbsp; &nbsp; &nbsp; &nbsp; ShowMessage('Ürün başarıyla eklendi.');</div><div>&nbsp; &nbsp; &nbsp; }</div><div><br></div><div>&nbsp; &nbsp; &nbsp; AddDataToGrid;</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; except</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Hata: ' + LastExceptionMessage);</div><div>&nbsp; &nbsp; }</div><div>&nbsp; }</div><div>&nbsp; }</div><div>}</div><div><br></div><div>{</div><div>&nbsp; MyForm = TclForm.Create(Self);</div><div>&nbsp; MyForm.SetFormColor('#c4c4c4', '#c4c4c4', clGVertical);</div><div><br></div><div>&nbsp; Lbl_Baslik = MyForm.AddNewProLabel(MyForm, 'Lbl_Baslik', 'Ürün Ekleme Sayfası');</div><div>&nbsp; Lbl_Baslik.Align = alTop;</div><div>&nbsp; Lbl_Baslik.Height = 60;</div><div>&nbsp; Lbl_Baslik.Margins.Top = 30;</div><div>&nbsp; Lbl_Baslik.clProSettings.FontSize = 26;</div><div>&nbsp; Lbl_Baslik.clProSettings.FontColor = clAlphaColor.clHexToColor('#fc0000');</div><div>&nbsp; Lbl_Baslik.clProSettings.FontVertAlign = palCenter;</div><div>&nbsp; Lbl_Baslik.clProSettings.FontHorzAlign = palCenter;</div><div>&nbsp; Lbl_Baslik.SetclProSettings(Lbl_Baslik.clProSettings);</div><div><br></div><div>&nbsp; leftPanel = MyForm.AddNewProPanel(MyForm, 'leftPanel');</div><div>&nbsp; leftPanel.Align = alLeft;</div><div>&nbsp; leftPanel.Width = 400;</div><div>&nbsp; leftPanel.Margins.Top = 20;</div><div>&nbsp; leftPanel.Margins.Left = 20;</div><div>&nbsp; leftPanel.Margins.Right = 20;</div><div><br></div><div>&nbsp; rightPanel = MyForm.AddNewProPanel(MyForm, 'rightPanel');</div><div>&nbsp; rightPanel.Align = alClient;</div><div>&nbsp; rightPanel.Margins.Top = 20;</div><div>&nbsp; rightPanel.Margins.Left = 20;</div><div>&nbsp; rightPanel.Margins.Right = 20;</div><div><br></div><div>&nbsp; // --- SIRALI ---</div><div>&nbsp; // Ürün Kodu</div><div>&nbsp; Lbl_StokKodu = MyForm.AddNewProLabel(leftPanel, 'Lbl_StokKodu', 'Ürün Kodu');</div><div>&nbsp; Lbl_StokKodu.Align = alTop;</div><div>&nbsp; Lbl_StokKodu.Height = 30;</div><div>&nbsp; Lbl_StokKodu.clProSettings.FontSize = 14;</div><div>&nbsp; Lbl_StokKodu.SetclProSettings(Lbl_StokKodu.clProSettings);</div><div><br></div><div>&nbsp; Edt_StokKodu = MyForm.AddNewProEdit(leftPanel, 'Edt_StokKodu', '');</div><div>&nbsp; Edt_StokKodu.Align = alTop;</div><div>&nbsp; Edt_StokKodu.Height = 40;</div><div>&nbsp; Edt_StokKodu.Margins.Top = 10;</div><div>&nbsp; Edt_StokKodu.SetclProSettings(Edt_StokKodu.clProSettings);</div><div><br></div><div>&nbsp; // Ürün Adı</div><div>&nbsp; Lbl_UrunAdi = MyForm.AddNewProLabel(leftPanel, 'Lbl_UrunAdi', 'Ürün Adı');</div><div>&nbsp; Lbl_UrunAdi.Align = alTop;</div><div>&nbsp; Lbl_UrunAdi.Height = 30;</div><div>&nbsp; Lbl_UrunAdi.clProSettings.FontSize = 14;</div><div>&nbsp; Lbl_UrunAdi.SetclProSettings(Lbl_UrunAdi.clProSettings);</div><div><br></div><div>&nbsp; Edt_UrunAdi = MyForm.AddNewProEdit(leftPanel, 'Edt_UrunAdi', '');</div><div>&nbsp; Edt_UrunAdi.Align = alTop;</div><div>&nbsp; Edt_UrunAdi.Height = 40;</div><div>&nbsp; Edt_UrunAdi.Margins.Top = 10;</div><div>&nbsp; Edt_UrunAdi.SetclProSettings(Edt_UrunAdi.clProSettings);</div><div><br></div><div>&nbsp; // Stok Miktarı</div><div>&nbsp; Lbl_StokMiktari = MyForm.AddNewProLabel(leftPanel, 'Lbl_StokMiktari', 'Stok Miktarı');</div><div>&nbsp; Lbl_StokMiktari.Align = alTop;</div><div>&nbsp; Lbl_StokMiktari.Height = 30;</div><div>&nbsp; Lbl_StokMiktari.clProSettings.FontSize = 14;</div><div>&nbsp; Lbl_StokMiktari.SetclProSettings(Lbl_StokMiktari.clProSettings);</div><div><br></div><div>&nbsp; Edt_StokMiktari = MyForm.AddNewProEdit(leftPanel, 'Edt_StokMiktari', '');</div><div>&nbsp; Edt_StokMiktari.Align = alTop;</div><div>&nbsp; Edt_StokMiktari.Height = 40;</div><div>&nbsp; Edt_StokMiktari.Margins.Top = 10;</div><div>&nbsp; Edt_StokMiktari.SetclProSettings(Edt_StokMiktari.clProSettings);</div><div><br></div><div>&nbsp; // Depo Yeri</div><div>&nbsp; Lbl_DepoYeriID = MyForm.AddNewProLabel(leftPanel, 'Lbl_DepoYeriID', 'Depo Yeri ID');</div><div>&nbsp; Lbl_DepoYeriID.Align = alTop;</div><div>&nbsp; Lbl_DepoYeriID.Height = 30;</div><div>&nbsp; Lbl_DepoYeriID.clProSettings.FontSize = 14;</div><div>&nbsp; Lbl_DepoYeriID.SetclProSettings(Lbl_DepoYeriID.clProSettings);</div><div><br></div><div>&nbsp; Edt_DepoYeriID = MyForm.AddNewProEdit(leftPanel, 'Edt_DepoYeriID', '');</div><div>&nbsp; Edt_DepoYeriID.Align = alTop;</div><div>&nbsp; Edt_DepoYeriID.Height = 40;</div><div>&nbsp; Edt_DepoYeriID.Margins.Top = 10;</div><div>&nbsp; Edt_DepoYeriID.SetclProSettings(Edt_DepoYeriID.clProSettings);</div><div><br></div><div>&nbsp; // Birim Fiyat</div><div>&nbsp; Lbl_BirimFiyat = MyForm.AddNewProLabel(leftPanel, 'Lbl_BirimFiyat', 'Birim Fiyat');</div><div>&nbsp; Lbl_BirimFiyat.Align = alTop;</div><div>&nbsp; Lbl_BirimFiyat.Height = 30;</div><div>&nbsp; Lbl_BirimFiyat.clProSettings.FontSize = 14;</div><div>&nbsp; Lbl_BirimFiyat.SetclProSettings(Lbl_BirimFiyat.clProSettings);</div><div><br></div><div>&nbsp; Edt_BirimFiyat = MyForm.AddNewProEdit(leftPanel, 'Edt_BirimFiyat', '');</div><div>&nbsp; Edt_BirimFiyat.Align = alTop;</div><div>&nbsp; Edt_BirimFiyat.Height = 40;</div><div>&nbsp; Edt_BirimFiyat.Margins.Top = 10;</div><div>&nbsp; Edt_BirimFiyat.SetclProSettings(Edt_BirimFiyat.clProSettings);</div><div><br></div><div>&nbsp; // Tarih</div><div>&nbsp; Lbl_Tarih = MyForm.AddNewProLabel(leftPanel, 'Lbl_Tarih', 'Tarih');</div><div>&nbsp; Lbl_Tarih.Align = alTop;</div><div>&nbsp; Lbl_Tarih.Height = 30;</div><div>&nbsp; Lbl_Tarih.clProSettings.FontSize = 14;</div><div>&nbsp; Lbl_Tarih.SetclProSettings(Lbl_Tarih.clProSettings);</div><div><br></div><div>&nbsp; DtEdt1 = MyForm.AddNewProDateEdit(leftPanel, 'DtEdt1');</div><div>&nbsp; DtEdt1.Align = alTop;</div><div>&nbsp; DtEdt1.Height = 40;</div><div>&nbsp; DtEdt1.Margins.Top = 10;</div><div>&nbsp; DtEdt1.SetclProSettings(DtEdt1.clProSettings);</div><div><br></div><div>&nbsp; // Buton</div><div>&nbsp; Btn_YeniUrunEkle = MyForm.AddNewProButton(leftPanel, 'Btn_YeniUrunEkle', 'Ürün Ekle');</div><div>&nbsp; Btn_YeniUrunEkle.Align = alTop;</div><div>&nbsp; Btn_YeniUrunEkle.Height = 50;</div><div>&nbsp; Btn_YeniUrunEkle.Margins.Top = 20;</div><div>&nbsp; Btn_YeniUrunEkle.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#4CAF50');</div><div>&nbsp; Btn_YeniUrunEkle.clProSettings.FontColor = clAlphaColor.clHexToColor('#ffffff');</div><div>&nbsp; Btn_YeniUrunEkle.clProSettings.FontSize = 16;</div><div>&nbsp; Btn_YeniUrunEkle.SetclProSettings(Btn_YeniUrunEkle.clProSettings);</div><div><br></div><div>&nbsp; MyGrid = MyForm.AddNewStringGrid(rightPanel, 'MyGrid');</div><div>&nbsp; MyGrid.Align = alClient;</div><div>&nbsp; MyGrid.ReadOnly = True;</div><div><br></div><div>&nbsp; selectQuery = TClSqlQuery.Create(nil);</div><div>&nbsp; Clomosy.DBSQLServerConnect('SQL Server', 'DESKTOP-E2HF8JM\SQLEXPRESS', 'sa', '1', 'StokYonetim', 1433);</div><div>&nbsp; selectQuery.Connection = Clomosy.DBSQLServerConnection;</div><div><br></div><div>&nbsp; AddDataToGrid;</div><div>&nbsp; MyForm.AddNewEvent(Btn_YeniUrunEkle, tbeOnClick, 'EkleButtonClick');</div><div>&nbsp; MyForm.clSetWindowState(fwsMaximized);</div><div><br></div><div>&nbsp; MyForm.Run;</div><div>}</div><div><br></div>]]>
   </description>
   <pubDate>Wed, 16 Jul 2025 12:04:29 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1092&amp;PID=2221#2221</guid>
  </item> 
 </channel>
</rss>