<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Fox4um]]></title>
		<link>http://www.fox4um.com/</link>
		<description><![CDATA[The most recent topics at Fox4um.]]></description>
		<lastBuildDate>Fri, 12 Mar 2010 06:55:16 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[USB port u dinlemek gelen sinyali klavye komutlarina cevirmek]]></title>
			<link>http://www.fox4um.com/topic/1567/usb-port-u-dinlemek-gelen-sinyali-klavye-komutlarina-cevirmek/new/posts/</link>
			<description><![CDATA[<p>Herkese Selam,
</p><p>Forum icinde USB yazip arama yaptim, birkac USB ile ilgili konu gordum ama istedigim cevabi bulamadim. O nedenle yeni konu actim. Umarim dogru yerde acmisimdir.
</p><p>Toggle Switch denen cihazlari belki bilirsiniz. En alta bi resmini ekledim. Bunun gibi belki 50 tanesini kullanarak bir panel yapmak istiyorum. Her biri belli bir klavye tusunu temsil edecek. 
</p><p>Bu isi bir klavyeyi sokup icindeki kucuk board kullanarak yapmak cok basit. Controller zaten orada. USB klavye. Hazir programlanmis. Windows a tanitma diye bi dert yok. Klavye icindeki plastik duzenekten hangi tusun controller daki hangi bacaklara bagli oldugunu takip ederek tus kombinasyonlarini bulabiliyorsunuz. Mesela benim elimdeki klavye ye gore DEL tut controller uzerinde 8. ve 12. bacaklara bagli. Resimdeki gibi bir toggle switch aldim ve bacaklarini controller ustundeki 8. ve 12. bacaga bagladim. Switch i ON yapinca DEL tusu calisiyor. OFF yapinca duruyor.
</p><p>Bu yontem harika ama bir dezavantaji var. Switch i ON yapinca DEL tusu surekli calisiyor. Ta ki OFF yapincaya kadar. Ben sadece 1 kez calismasini istiyorum.
</p><p>Sizce bunu Foxpro ile yapmak mumkun mu? Yani bi sekilde USB yada seri porttan bu switch in on/off durumu okuyup istedigim bir tusu basmak.
</p><p><span class="postimg"><img src="http://www.chesterelectronics.com/images/0001f8db_360x360.jpg" alt="http://www.chesterelectronics.com/images/0001f8db_360x360.jpg" /></span></p>]]></description>
			<author><![CDATA[dummy@example.com (ozgurtetik)]]></author>
			<pubDate>Fri, 12 Mar 2010 06:55:16 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1567/usb-port-u-dinlemek-gelen-sinyali-klavye-komutlarina-cevirmek/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[plain commandbutton]]></title>
			<link>http://www.fox4um.com/topic/1566/plain-commandbutton/new/posts/</link>
			<description><![CDATA[<p>plain command button lar yaptım. bazılarını tıklayınca ince çizgili çerçeve gözüküyor. bazılarında gözükmüyor. sebebini bulamadım. o çerçevenin çıkmamasını istiyorum. hepsi de aynı commandbutton class&#039;ından kalıtımla geliyor. hiçbirşey anlamadım bu işten. çok önemli birşey değil ama biri başka biri başka gıcık ediyor beni.</p>]]></description>
			<author><![CDATA[dummy@example.com (metin)]]></author>
			<pubDate>Wed, 10 Mar 2010 15:48:19 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1566/plain-commandbutton/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[Cesar'dan Özcan'a]]></title>
			<link>http://www.fox4um.com/topic/1561/cesardan-ozcana/new/posts/</link>
			<description><![CDATA[<p>Özcan,
<br />Cesar Foxite.com da yazdigin bir kelimeyi tam anlayamamis 
<br />FRX dosyaları Projende Include halde iken FoxyPreviewer.app yi projende kullanmakta sıkıntı cektigin seklinde anlamis.
</p><p>asagidaki linkte bu konu ile ilgili aciklama yaptigini ve sana bildirmemi istedi. Ayrica Foxite.com uzerinden destek talebinde bulunman halinde seve seve yardimci olacagini belirtiyor... elciye zeval olmaz <img src="http://www.fox4um.com/img/smilies/smile.png" width="15" height="15" alt="smile" />
</p><p><a href="http://www.foxite.com/archives/0000254671.htm">http://www.foxite.com/archives/0000254671.htm</a></p>]]></description>
			<author><![CDATA[dummy@example.com (ozcan)]]></author>
			<pubDate>Wed, 10 Mar 2010 13:00:26 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1561/cesardan-ozcana/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[LocatorGrid in Foxy Classes]]></title>
			<link>http://www.fox4um.com/topic/1565/locatorgrid-in-foxy-classes/new/posts/</link>
			<description><![CDATA[<p>In the instructions for the LocatorGrid in Foxy Classes, it says, i.a.:
</p><p>&quot;To use the LocatorGrid, simply drop it on your VFP form and set a few properties. These include csql, followField, followTable, followTag, isSpecialCharSet, lInGrid, lKeepFormat, nCurRec, mapCharSlower, and mapCharSupper.&quot;
</p><p>First, it says &quot;These include&quot;. Does this mean that there are other properties that should be changed?
</p><p>Second, is there any place where the these properties are described, so that one would know what changes to make?
</p><p>Regards,
</p><p>Hans L</p>]]></description>
			<author><![CDATA[dummy@example.com (Hans L)]]></author>
			<pubDate>Tue, 09 Mar 2010 20:49:14 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1565/locatorgrid-in-foxy-classes/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[Logo tiger 2 için .net ten VFP ya kod çevirimi]]></title>
			<link>http://www.fox4um.com/topic/1553/logo-tiger-2-icin-net-ten-vfp-ya-kod-cevirimi/new/posts/</link>
			<description><![CDATA[<p>Selamlar;
<br />Logo tiger2 için Dll dosyası aracılığı ile stok kartı açtırmak istiyorum. Logodan alınan DLL dosyası mevcut.
<br /></p><div class="codebox"><div class="head">Visual Fox Pro</div><table class="visualfoxpro fxcode"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
<br />2
<br />3
<br />4
<br />5
<br />6
<br />7
<br />8
<br />9
<br />10
<br />11
<br />12
<br />13
<br />14
<br />15
<br />16
<br />17
<br />18
<br />19
<br />20
<br /></pre></td><td class="de1"><pre class="de1"><span class="kw1">Local</span> UnityApp <span class="kw2">As</span> Variant
<br /><span class="kw1">Local</span> LastError <span class="kw2">As</span> Variant
<br />UnityApp <span class="sy0">=</span> <span class="kw1">Createobject</span><span class="br0">&#40;</span><span class="st0">&quot;UnityObjects.UnityApplication&quot;</span><span class="br0">&#41;</span> 
<br /><span class="kw1">If</span> <span class="sy0">!</span><span class="kw1">Isnull</span><span class="br0">&#40;</span>UnityApp<span class="br0">&#41;</span>
<br />&nbsp; &nbsp; <span class="kw1">If</span> UnityApp<span class="sy0">.</span><span class="me1">connected</span><span class="sy0">=.</span><span class="kw3">T</span><span class="sy0">.</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw2">Wait</span> Window <span class="br0">&#40;</span>'Logo Ok'<span class="br0">&#41;</span> Nowa
<br />&nbsp; &nbsp; <span class="kw1">Else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; UnityApp<span class="sy0">.</span><span class="me1">Disconnect</span>
<br />&nbsp; &nbsp; <span class="kw1">Endif</span>
<br /><span class="kw1">Else</span>
<br />&nbsp; &nbsp; LastError <span class="sy0">=</span> UnityApp<span class="sy0">.</span><span class="me1">GetLastError</span>
<br />&nbsp; &nbsp; UnityApp <span class="sy0">=</span> <span class="sy0">.</span><span class="kw2">F</span><span class="sy0">.</span>
<br />&nbsp; &nbsp; <span class="me1">MsgBox</span> <span class="st0">&quot;Unity Application object not created ...&quot;</span>
<br /><span class="kw1">Endif</span>
<br /><span class="kw1">If</span> UnityApp<span class="sy0">.</span><span class="me1">Login</span><span class="br0">&#40;</span><span class="st0">&quot;LOGO&quot;</span><span class="sy0">,</span> <span class="st0">&quot;LOGO&quot;</span><span class="sy0">,</span><span class="nu0">99</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; <span class="kw2">Wait</span> Window <span class="br0">&#40;</span>'Firma Ok'<span class="br0">&#41;</span> Nowa
<br /><span class="kw1">Else</span>
<br />&nbsp; &nbsp; <span class="kw2">Wait</span> Window <span class="br0">&#40;</span><span class="st0">&quot;Hata:&quot;</span> <span class="sy0">+</span> <span class="kw2">Str</span><span class="br0">&#40;</span>UnityApp<span class="sy0">.</span><span class="me1">GetLastError</span><span class="br0">&#41;</span><span class="sy0">+</span><span class="st0">&quot; &quot;</span><span class="sy0">+</span> UnityApp<span class="sy0">.</span><span class="me1">GetLastErrorString</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; UnityApp<span class="sy0">.</span><span class="me1">CompanyLogout</span>
<br /><span class="kw1">Endif</span></pre></td></tr></tbody></table></div><p>
<br />buraya kadar sorunsuz çalışıyor.
<br />Aşağıdaki&nbsp; .net kodu kullanarak yeni stok kartı ekletmek isityorum .net bilgim fazla yok yardımcı olabilirmisiniz.
</p><p>Çalışan orijinal .net kodu.
<br /></p><div class="codebox"><div class="head">C#</div><table class="csharp fxcode"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
<br />2
<br />3
<br />4
<br />5
<br />6
<br />7
<br />8
<br />9
<br />10
<br />11
<br />12
<br />13
<br />14
<br />15
<br />16
<br />17
<br />18
<br />19
<br />20
<br />21
<br />22
<br />23
<br />24
<br />25
<br />26
<br />27
<br />28
<br />29
<br />30
<br />31
<br />32
<br />33
<br />34
<br />35
<br />36
<br />37
<br />38
<br />39
<br />40
<br />41
<br />42
<br />43
<br />44
<br />45
<br />46
<br />47
<br />48
<br />49
<br />50
<br />51
<br />52
<br />53
<br />54
<br />55
<br />56
<br />57
<br />58
<br />59
<br />60
<br />61
<br />62
<br />63
<br />64
<br />65
<br />66
<br />67
<br />68
<br />69
<br />70
<br />71
<br />72
<br />73
<br />74
<br />75
<br />76
<br />77
<br />78
<br />79
<br />80
<br />81
<br />82
<br />83
<br />84
<br />85
<br />86
<br />87
<br />88
<br />89
<br />90
<br />91
<br />92
<br />93
<br />94
<br />95
<br />96
<br />97
<br />98
<br />99
<br />100
<br />101
<br />102
<br />103
<br />104
<br />105
<br />106
<br />107
<br />108
<br />109
<br />110
<br />111
<br />112
<br />113
<br />114
<br />115
<br />116
<br />117
<br />118
<br />119
<br />120
<br />121
<br />122
<br />123
<br />124
<br />125
<br />126
<br />127
<br />128
<br />129
<br />130
<br />131
<br />132
<br />133
<br />134
<br />135
<br />136
<br />137
<br />138
<br />139
<br />140
<br />141
<br />142
<br />143
<br />144
<br />145
<br />146
<br />147
<br />148
<br />149
<br />150
<br />151
<br />152
<br />153
<br />154
<br />155
<br />156
<br />157
<br />158
<br />159
<br />160
<br />161
<br />162
<br />163
<br />164
<br />165
<br />166
<br />167
<br />168
<br />169
<br />170
<br />171
<br />172
<br />173
<br />174
<br />175
<br />176
<br />177
<br />178
<br />179
<br />180
<br />181
<br />182
<br />183
<br />184
<br />185
<br />186
<br />187
<br />188
<br />189
<br />190
<br />191
<br />192
<br />193
<br />194
<br />195
<br />196
<br />197
<br />198
<br />199
<br />200
<br />201
<br />202
<br />203
<br />204
<br />205
<br />206
<br />207
<br />208
<br />209
<br />210
<br />211
<br />212
<br />213
<br />214
<br />215
<br />216
<br />217
<br />218
<br />219
<br />220
<br />221
<br />222
<br /></pre></td><td class="de1"><pre class="de1"><span class="kw1">using</span> <span class="co3">System</span><span class="sy0">;</span>
<br /><span class="kw1">using</span> <span class="co3">System.Collections.Generic</span><span class="sy0">;</span>
<br /><span class="kw1">using</span> <span class="co3">System.Linq</span><span class="sy0">;</span>
<br /><span class="kw1">using</span> <span class="co3">System.Text</span><span class="sy0">;</span>
<br /><span class="kw1">using</span> <span class="co3">UnityObjects</span><span class="sy0">;</span>
<br /><span class="kw1">using</span> <span class="co3">System.Windows.Forms</span><span class="sy0">;</span>
<br />&nbsp;
<br /><span class="kw1">namespace</span> hw
<br /><span class="br0">&#123;</span>
<br />&nbsp; &nbsp; <span class="kw1">public</span> <span class="kw4">class</span> mg <span class="co1">// my globals</span>
<br />&nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> UnityApplicationClass uo<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> UnityeBagliyim<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; 
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw1">void</span> IlkDegerler<span class="br0">&#40;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; uo <span class="sy0">=</span> <a href="http://www.google.com/search?q=new+msdn.microsoft.com"><span class="kw3">new</span></a> UnityApplicationClass<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> lesson_Connect<span class="br0">&#40;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span><span class="br0">&#40;</span>uo.<span class="me1">Connect</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;connect ok&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> true<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;connect:&quot;</span> <span class="sy0">+</span> uo.<span class="me1">GetLastError</span><span class="br0">&#40;</span><span class="br0">&#41;</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">+</span><span class="st0">&quot; &quot;</span><span class="sy0">+</span>uo.<span class="me1">GetLastErrorString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> false<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> lesson_AddFirm<span class="br0">&#40;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> sEmsg <span class="sy0">=</span> <span class="st0">&quot;&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span><span class="sy0">!</span>uo.<span class="me1">Connected</span><span class="br0">&#41;</span><span class="br0">&#123;</span>MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;bağlan da gel&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>return <span class="kw1">false</span> <span class="sy0">;</span><span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UnityObjects.<span class="me1">Firm</span> f <span class="sy0">=</span> mg.<span class="me1">uo</span>.<span class="me1">CAPI</span>.<span class="me1">Firms</span>.<span class="me1">NewFirm</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; f.<span class="me1">FirmNr</span> <span class="sy0">=</span> <span class="nu0">44</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; f.<span class="me1">name</span> <span class="sy0">=</span> <span class="st0">&quot;malatya&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>f.<span class="me1">Post</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;firma kayıt edildi&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sEmsg <span class="sy0">=</span> <span class="st0">&quot;hata :&quot;</span> <span class="sy0">+</span>mg.<span class="me1">uo</span>.<span class="me1">GetLastError</span><span class="br0">&#40;</span><span class="br0">&#41;</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">+</span> <span class="st0">&quot; &quot;</span> <span class="sy0">+</span> mg.<span class="me1">uo</span>.<span class="me1">GetLastErrorString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span>sEmsg<span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; f <span class="sy0">=</span> null<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> true<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> lesson_AddFactoryDivision<span class="br0">&#40;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span><span class="sy0">!</span>mg.<span class="me1">uo</span>.<span class="me1">Connected</span><span class="br0">&#41;</span> <span class="br0">&#123;</span> MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;bağlan da gel&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="kw1">return</span> false<span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> sEmsg <span class="sy0">=</span> <span class="st0">&quot;&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UnityObjects.<span class="me1">FactoryDivision</span> fd<span class="sy0">=</span> mg.<span class="me1">uo</span>.<span class="me1">CAPI</span>.<span class="me1">Firms</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">Factories</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">FactoryDivisions</span>.<span class="me1">NewFactoryDivision</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fd.<span class="me1">name</span> <span class="sy0">=</span> <span class="st0">&quot;şimdi ne olcak&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>fd.<span class="me1">Post</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;aha eklenti tamam&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sEmsg <span class="sy0">=</span> <span class="st0">&quot;hata :&quot;</span> <span class="sy0">+</span> mg.<span class="me1">uo</span>.<span class="me1">GetLastError</span><span class="br0">&#40;</span><span class="br0">&#41;</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">+</span> <span class="st0">&quot; - &quot;</span> <span class="sy0">+</span> mg.<span class="me1">uo</span>.<span class="me1">GetLastErrorString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span>sEmsg<span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> true<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> Baglan<span class="br0">&#40;</span><span class="kw4">string</span> username, <span class="kw4">string</span> password, <span class="kw4">int</span> firmnumber<span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>uo.<span class="me1">Connected</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Unity e bağlısınız. Tekrar bağlantı için önce var olan bağlantıyı kesmelisiniz&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> false<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">try</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; uo.<span class="me1">Login</span><span class="br0">&#40;</span>username, password, firmnumber<span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>uo.<span class="me1">Connected</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> <span class="kw1">return</span> true<span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> <span class="kw1">return</span> false<span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">catch</span> <span class="br0">&#40;</span>Exception e<span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Bağlantı Denemesinde Hata Oluştu:&quot;</span><span class="sy0">+</span> e.<span class="me1">Message</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> false<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> BaglantiyiKes<span class="br0">&#40;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span><span class="sy0">!</span>uo.<span class="me1">Connected</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Unity e bağlı olmadığınız için bağlantı kesilmesine gerek yoktur&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> false<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; uo.<span class="me1">Disconnect</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Bağlantınız kesildi&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> true<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> lesson_addclcard<span class="br0">&#40;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> msg<span class="sy0">=</span><span class="st0">&quot;&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span><span class="sy0">!</span>mg.<span class="me1">uo</span>.<span class="me1">LoggedIn</span><span class="br0">&#41;</span> <span class="br0">&#123;</span> MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;bağlan da gel&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="kw1">return</span> false<span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Data clcard <span class="sy0">=</span> mg.<span class="me1">uo</span>.<span class="me1">NewDataObject</span><span class="br0">&#40;</span>DataObjectType.<span class="me1">doAccountsRP</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard.<a href="http://www.google.com/search?q=new+msdn.microsoft.com"><span class="kw3">New</span></a><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;ACCOUNT_TYPE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span><span class="sy0">=</span><span class="nu0">3</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;CODE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span><span class="sy0">=</span><span class="st0">&quot;00045&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;TITLE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span><span class="sy0">=</span><span class="st0">&quot;isim&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;ADDRESS1&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;adres&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;TOWN_CODE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="nu0">1</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;TOWN&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;Aliağa&quot;</span><span class="sy0">;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>clcard.<span class="me1">Post</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Cari kart eklendi&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> 
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>clcard.<span class="me1">ErrorCode</span><span class="sy0">==</span><span class="nu0">0</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> <span class="co1">// hata var ama hata veri tabanı hatası değil. Öyleyse hata XML hatasıdır.</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">+=</span><span class="st0">&quot; XML error&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> h <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> h <span class="sy0">&lt;=</span> clcard.<span class="me1">ValidateErrors</span>.<span class="me1">Count</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="sy0">;</span> h<span class="sy0">++</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">+=</span> <span class="st0">&quot;Err Id:&quot;</span> <span class="sy0">+</span> clcard.<span class="me1">ValidateErrors</span><span class="br0">&#91;</span>h<span class="br0">&#93;</span>.<span class="me1">ID</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">+=</span> <span class="st0">&quot;Err Code:&quot;</span> <span class="sy0">+</span> clcard.<span class="me1">ValidateErrors</span><span class="br0">&#91;</span>h<span class="br0">&#93;</span>.<span class="me1">Error</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span><span class="co1">// hata var ve hata veri tabanı hatası.</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">=</span> <span class="st0">&quot;Veri Tabanı Hatası:&quot;</span> <span class="sy0">+</span> clcard.<span class="me1">ErrorCode</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">+</span><span class="st0">&quot; -&quot;</span> <span class="sy0">+</span> &nbsp;clcard.<span class="me1">ErrorDesc</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span>msg<span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clcard<span class="sy0">=</span>null<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> true<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> lesson_addSalesOrder<span class="br0">&#40;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> msg <span class="sy0">=</span> <span class="st0">&quot;&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span><span class="sy0">!</span>mg.<span class="me1">uo</span>.<span class="me1">LoggedIn</span><span class="br0">&#41;</span> <span class="br0">&#123;</span> MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;bağlan da gel&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="kw1">return</span> false<span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Data ss <span class="sy0">=</span> mg.<span class="me1">uo</span>.<span class="me1">NewDataObject</span><span class="br0">&#40;</span>DataObjectType.<span class="me1">doSalesOrderSlip</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ss.<a href="http://www.google.com/search?q=new+msdn.microsoft.com"><span class="kw3">New</span></a><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ss.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;NUMBER&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;~&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ss.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;DATE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="kw5">System</span>.<span class="me1">DateTime</span>.<span class="me1">Today</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ss.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;ARP_CODE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;0000000000000002&quot;</span><span class="sy0">;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Lines ssLines <span class="sy0">=</span> ss.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;TRANSACTIONS&quot;</span><span class="br0">&#41;</span>.<span class="me1">Lines</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssLines.<span class="me1">AppendLine</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssLines<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;TYPE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssLines<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;MASTER_CODE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;000000000000000000000001&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssLines<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;QUANTITY&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="nu0">1</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssLines<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;PRICE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="nu0">11</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssLines<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;VAT_RATE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="nu0">8</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssLines<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;UNIT_CODE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;ADET&quot;</span><span class="sy0">;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// her satır için LOT kayıtlarının eklenmesi aşağıdaki gibidir.</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// Lines ssLineSLDetail = ssLines[0].FieldByName(&quot;SL_DETAILS&quot;).Lines;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// ssLineSLDetail.AppendLine();</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>ss.<span class="me1">Post</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;satış siparişi eklendi&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>ss.<span class="me1">ErrorCode</span> <span class="sy0">==</span> <span class="nu0">0</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> <span class="co1">// hata var ama hata veri tabanı hatası değil. Öyleyse hata XML hatasıdır.</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">+=</span> <span class="st0">&quot; XML error&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> h <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> h <span class="sy0">&lt;=</span> ss.<span class="me1">ValidateErrors</span>.<span class="me1">Count</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="sy0">;</span> h<span class="sy0">++</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">+=</span> <span class="st0">&quot;Err Id:&quot;</span> <span class="sy0">+</span> ss.<span class="me1">ValidateErrors</span><span class="br0">&#91;</span>h<span class="br0">&#93;</span>.<span class="me1">ID</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">+=</span> <span class="st0">&quot;Err Code:&quot;</span> <span class="sy0">+</span> ss.<span class="me1">ValidateErrors</span><span class="br0">&#91;</span>h<span class="br0">&#93;</span>.<span class="me1">Error</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span><span class="co1">// hata var ve hata veri tabanı hatası.</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msg <span class="sy0">=</span> <span class="st0">&quot;Veri Tabanı Hatası:&quot;</span> <span class="sy0">+</span> ss.<span class="me1">ErrorCode</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">+</span> <span class="st0">&quot; -&quot;</span> <span class="sy0">+</span> ss.<span class="me1">ErrorDesc</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span>msg<span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ss <span class="sy0">=</span> null<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> true<span class="sy0">;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp;
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">static</span> <span class="kw4">bool</span> MalzemeKartAktarimi<span class="br0">&#40;</span>TextBox tbInfo<span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> sEmsg <span class="sy0">=</span> <span class="st0">&quot;&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Data LogoMalzemeKart <span class="sy0">=</span> mg.<span class="me1">uo</span>.<span class="me1">NewDataObject</span><span class="br0">&#40;</span>DataObjectType.<span class="me1">doMaterial</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LogoMalzemeKart.<a href="http://www.google.com/search?q=new+msdn.microsoft.com"><span class="kw3">New</span></a><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LogoMalzemeKart.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;ACCOUNT_TYPE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="nu0">3</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LogoMalzemeKart.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;CODE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;12345&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LogoMalzemeKart.<span class="me1">DataFields</span>.<span class="me1">FieldByName</span><span class="br0">&#40;</span><span class="st0">&quot;TITLE&quot;</span><span class="br0">&#41;</span>.<span class="me1">Value</span> <span class="sy0">=</span> <span class="st0">&quot;malzemem&quot;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>LogoMalzemeKart.<span class="me1">Post</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;kart kayıt edildi&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sEmsg <span class="sy0">=</span> LogoMalzemeKart.<span class="me1">ErrorDesc</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> h <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> h <span class="sy0">&lt;=</span> LogoMalzemeKart.<span class="me1">ValidateErrors</span>.<span class="me1">Count</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="sy0">;</span> h<span class="sy0">++</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sEmsg <span class="sy0">+=</span> <span class="st0">&quot;Err Id:&quot;</span> <span class="sy0">+</span> LogoMalzemeKart.<span class="me1">ValidateErrors</span><span class="br0">&#91;</span>h<span class="br0">&#93;</span>.<span class="me1">ID</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sEmsg <span class="sy0">+=</span> <span class="st0">&quot;Err Code:&quot;</span> <span class="sy0">+</span> LogoMalzemeKart.<span class="me1">ValidateErrors</span><span class="br0">&#91;</span>h<span class="br0">&#93;</span>.<span class="me1">Error</span>.<span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.<span class="me1">Show</span><span class="br0">&#40;</span>sEmsg<span class="br0">&#41;</span><span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LogoMalzemeKart <span class="sy0">=</span> null<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">return</span> true<span class="sy0">;</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span><span class="co1">// end of MalzemeKarti</span>
<br />&nbsp;
<br />&nbsp;
<br />&nbsp; &nbsp; <span class="br0">&#125;</span>
<br /><span class="br0">&#125;</span></pre></td></tr></tbody></table></div>]]></description>
			<author><![CDATA[dummy@example.com (metin)]]></author>
			<pubDate>Tue, 09 Mar 2010 16:31:36 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1553/logo-tiger-2-icin-net-ten-vfp-ya-kod-cevirimi/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[Büyükler olarak önerinize ihtiyacım var]]></title>
			<link>http://www.fox4um.com/topic/1564/buyukler-olarak-onerinize-ihtiyacim-var/new/posts/</link>
			<description><![CDATA[<p>Selam
<br />10 yıldır Özel bir dershanede bilgiişlemde çalışmaktayım. Programcılık mezunuyum fakat işe ilk girdiğimde ünix donanımları ve sistemi ile uğraştım. son 3 yıldır fox ile içiçeyim ve 2.6, 6.0 ve en son 9.0 kullandım. Şüküt ne istersem yapabiliyorum.
</p><p>Sorum şu;
<br />VFP 9.0 &#039;dan sonra devam etmeyecek. Edecekse de haberim yok.
<br />C# mı? Yoksa VB mi? veya siz ne tavsiye edersiniz ?&nbsp; Foxdaki kadar pratik işlemler yapmam gerekecek</p>]]></description>
			<author><![CDATA[dummy@example.com (metin)]]></author>
			<pubDate>Tue, 09 Mar 2010 14:41:31 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1564/buyukler-olarak-onerinize-ihtiyacim-var/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[Başka Bir Pcnin Mac Adresini almak]]></title>
			<link>http://www.fox4um.com/topic/1562/baska-bir-pcnin-mac-adresini-almak/new/posts/</link>
			<description><![CDATA[<p>Öncelikle Herkese Merhabalar;
<br />Benim Sorum İstediğim Kendi Ağımda olan bir pcnin mac adresini aldırabilir miyim ?
<br />Sorumu Cevaplayanlara Şimdiden teşekkürler</p>]]></description>
			<author><![CDATA[dummy@example.com (antepli)]]></author>
			<pubDate>Mon, 08 Mar 2010 22:14:26 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1562/baska-bir-pcnin-mac-adresini-almak/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[Alphanumeric key incrementing routine]]></title>
			<link>http://www.fox4um.com/topic/1563/alphanumeric-key-incrementing-routine/new/posts/</link>
			<description><![CDATA[<p>UT den Sergey Berezniker Blogunda gördügüm Alfa Numeric alanlar ile sirali anahtar uretme kodlari
</p><div class="codebox"><div class="head">Visual Fox Pro</div><table class="visualfoxpro fxcode"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
<br />2
<br />3
<br />4
<br />5
<br />6
<br />7
<br />8
<br />9
<br />10
<br />11
<br />12
<br />13
<br />14
<br />15
<br />16
<br />17
<br />18
<br />19
<br />20
<br />21
<br />22
<br />23
<br />24
<br />25
<br />26
<br />27
<br />28
<br />29
<br />30
<br />31
<br />32
<br />33
<br />34
<br />35
<br />36
<br />37
<br />38
<br />39
<br />40
<br />41
<br />42
<br />43
<br />44
<br />45
<br />46
<br />47
<br />48
<br />49
<br />50
<br />51
<br />52
<br />53
<br />54
<br />55
<br />56
<br />57
<br />58
<br />59
<br />60
<br />61
<br />62
<br />63
<br />64
<br />65
<br />66
<br />67
<br />68
<br />69
<br />70
<br />71
<br />72
<br />73
<br />74
<br />75
<br />76
<br />77
<br />78
<br />79
<br />80
<br />81
<br />82
<br />83
<br />84
<br />85
<br />86
<br />87
<br />88
<br />89
<br />90
<br />91
<br />92
<br />93
<br />94
<br />95
<br />96
<br />97
<br /></pre></td><td class="de1"><pre class="de1"><span class="sy0">*</span>
<br /><span class="sy0">*</span> Creates <span class="kw1">next</span> <span class="kw3">string</span> <span class="kw2">key</span> <span class="kw2">from</span> the passed one using specified <span class="kw2">set</span> <span class="kw3">of</span> characters
<br /><span class="sy0">*</span>
<br /><span class="sy0">*</span> <span class="kw1">Parameters</span>
<br /><span class="sy0">*</span> &nbsp; &nbsp;<span class="nu0">1</span> <span class="sy0">-</span> Current <span class="kw2">Key</span>
<br /><span class="sy0">*</span> &nbsp; &nbsp;<span class="nu0">2</span> <span class="sy0">-</span> Defines the <span class="kw4">list</span> <span class="kw3">of</span> allowed characters
<br /><span class="sy0">*</span> &nbsp; &nbsp; &nbsp; &nbsp;BASEnn <span class="sy0">-</span> See <span class="kw1">DO</span> <span class="kw1">CASE</span> <span class="kw2">in</span> the body <span class="kw3">of</span> the <span class="kw3">program</span>
<br /><span class="sy0">*</span> &nbsp; &nbsp; &nbsp; &nbsp;<span class="kw4">CUSTOM</span> <span class="sy0">-</span> the <span class="kw4">list</span> <span class="kw3">of</span> <span class="kw2">character</span> <span class="kw2">as</span> parameter <span class="nu0">3</span>
<br /><span class="sy0">*</span> &nbsp; &nbsp;<span class="nu0">3</span> <span class="sy0">-</span> <span class="kw4">List</span> <span class="kw3">of</span> characters
<br /><span class="sy0">*</span>
<br /><span class="sy0">*</span> Returns &nbsp; &nbsp; <span class="kw1">Next</span> <span class="kw2">key</span>
<br /><span class="sy0">*</span>
<br /><span class="sy0">*</span> &nbsp; <span class="kw2">Note</span> <span class="nu0">1</span> &nbsp;Routine ignores <span class="br0">&#40;</span>doesn'<span class="kw3">t</span> <span class="kw1">change</span><span class="br0">&#41;</span> positions <span class="kw1">with</span> the characters <span class="kw3">not</span> <span class="kw2">in</span> the specified <span class="kw4">list</span>
<br /><span class="sy0">*</span> &nbsp; <span class="kw2">Note</span> <span class="nu0">2</span> &nbsp;<span class="kw3">When</span> <span class="kw2">max</span> possible <span class="kw4">value</span> <span class="kw2">is</span> reached<span class="sy0">,</span> the <span class="kw1">next</span> <span class="kw2">return</span> <span class="kw4">value</span> will be the <span class="kw2">min</span> possible <span class="kw4">value</span>
<br /><span class="sy0">*</span>
<br />&nbsp;
<br /><span class="kw1">FUNCTION</span> NextKey
<br /><span class="kw1">LPARAMETERS</span> tcOldVal<span class="sy0">,</span> tcOpt<span class="sy0">,</span> tcCharList
<br /><span class="kw1">LOCAL</span> lcNewVal<span class="sy0">,</span> i<span class="sy0">,</span> lcDigits<span class="sy0">,</span> lcLetters<span class="sy0">,</span> lnCharListLen<span class="sy0">,</span> lcOldChar<span class="sy0">,</span> lcNewChar<span class="sy0">,</span> lcCharList<span class="sy0">,</span> lnPos<span class="sy0">,</span> lcOpt
<br /><span class="kw1">LOCAL</span> lnNextPos
<br />&nbsp;
<br />lcOpt <span class="sy0">=</span> <span class="kw1">IIF</span><span class="br0">&#40;</span><span class="kw4">EMPTY</span><span class="br0">&#40;</span>tcOpt<span class="br0">&#41;</span><span class="sy0">,</span> <span class="st0">&quot;BASE10&quot;</span><span class="sy0">,</span> <span class="kw2">UPPER</span><span class="br0">&#40;</span>tcOpt<span class="br0">&#41;</span><span class="br0">&#41;</span>
<br /><span class="sy0">*</span> <span class="kw2">Get</span> the <span class="kw4">list</span> <span class="kw3">of</span> appropriate characters
<br />lcCharList <span class="sy0">=</span> NextKeyFillCharList<span class="br0">&#40;</span>lcOpt<span class="sy0">,</span> tcCharList<span class="br0">&#41;</span>
<br />lnCharListLen <span class="sy0">=</span> <span class="kw2">LEN</span><span class="br0">&#40;</span>lcCharList<span class="br0">&#41;</span>
<br />lcNewVal <span class="sy0">=</span> tcOldVal
<br />&nbsp;
<br /><span class="sy0">*</span> <span class="kw1">Scan</span> <span class="kw3">string</span> <span class="kw2">from</span> the <span class="kw3">right</span> <span class="kw3">to</span> the <span class="kw4">left</span>
<br /><span class="kw1">FOR</span> i <span class="sy0">=</span> <span class="kw2">LEN</span><span class="br0">&#40;</span>lcNewVal<span class="br0">&#41;</span> <span class="kw3">TO</span> <span class="nu0">1</span> <span class="kw3">STEP</span> <span class="sy0">-</span><span class="nu0">1</span>
<br />&nbsp;
<br />&nbsp; &nbsp; lcOldChar <span class="sy0">=</span> <span class="kw2">SUBSTR</span><span class="br0">&#40;</span>tcOldVal<span class="sy0">,</span> i<span class="sy0">,</span> <span class="nu0">1</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">Is</span> the current charater <span class="kw2">in</span> the <span class="kw4">list</span><span class="sy0">?</span>
<br />&nbsp; &nbsp; lnPos <span class="sy0">=</span> <span class="kw2">AT</span><span class="br0">&#40;</span>lcOldChar<span class="sy0">,</span> lcCharList<span class="br0">&#41;</span>
<br />&nbsp; &nbsp; <span class="kw1">IF</span> lnPos <span class="sy0">=</span> <span class="nu0">0</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="sy0">*</span> <span class="kw3">Not</span> <span class="kw2">in</span> the <span class="kw4">list</span><span class="sy0">,</span> keep it
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw2">LOOP</span>
<br />&nbsp; &nbsp; <span class="kw1">ENDIF</span>
<br />&nbsp;
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">Get</span> the <span class="kw1">next</span> <span class="kw2">character</span> position
<br />&nbsp; &nbsp; lnNextPos <span class="sy0">=</span> <span class="br0">&#40;</span>lnPos <span class="sy0">%</span> lnCharListLen<span class="br0">&#41;</span> <span class="sy0">+</span> <span class="nu0">1</span>
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">Get</span> the <span class="kw1">next</span> <span class="kw2">character</span> 
<br />&nbsp; &nbsp; lcNewChar <span class="sy0">=</span> <span class="kw2">SUBSTR</span><span class="br0">&#40;</span>lcCharList<span class="sy0">,</span>lnNextPos<span class="sy0">,</span><span class="nu0">1</span><span class="br0">&#41;</span>
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">Stuff</span> it back <span class="kw2">in</span> the <span class="kw3">string</span>
<br />&nbsp; &nbsp; lcNewVal <span class="sy0">=</span> <span class="kw2">STUFF</span><span class="br0">&#40;</span>lcNewVal<span class="sy0">,</span> i<span class="sy0">,</span> <span class="nu0">1</span><span class="sy0">,</span> lcNewChar<span class="br0">&#41;</span>
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">Check</span> <span class="kw1">if</span> we have <span class="kw3">to</span> <span class="kw2">carry</span> over <span class="kw3">to</span> the <span class="kw1">next</span> position
<br />&nbsp; &nbsp; <span class="kw1">IF</span> lnNextPos <span class="sy0">&gt;</span> <span class="nu0">1</span>
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="sy0">*</span> We are done
<br />&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">EXIT</span>
<br />&nbsp; &nbsp; <span class="kw1">ENDIF</span>
<br />&nbsp;
<br /><span class="kw1">ENDFOR</span>
<br />&nbsp;
<br /><span class="kw2">RETURN</span> lcNewVal
<br /><span class="sy0">*------------------------------------------------------------</span>
<br /><span class="sy0">*</span> <span class="kw2">Fill</span> the <span class="kw4">list</span> <span class="kw3">of</span> characters based <span class="kw2">on</span> <span class="kw2">character</span> <span class="kw2">set</span> requested
<br /><span class="kw1">FUNCTION</span> NextKeyFillCharList
<br /><span class="kw1">LPARAMETERS</span> tcCharSet<span class="sy0">,</span> tcCharList
<br /><span class="kw1">LOCAL</span> lcCharList<span class="sy0">,</span> lcDigits<span class="sy0">,</span> lcLetters
<br /><span class="sy0">*</span> <span class="kw2">Fill</span> <span class="kw3">string</span> 'lcCharList' <span class="kw1">with</span> appropriate characters
<br />lcDigits <span class="sy0">=</span> <span class="st0">&quot;0123456789&quot;</span>
<br />lcLetters <span class="sy0">=</span> <span class="st0">&quot;ABCDEFGHIJKLMNOPQRSTUVWXYZ&quot;</span>
<br />&nbsp;
<br /><span class="kw1">DO</span> <span class="kw1">CASE</span>
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">=</span> <span class="st0">&quot;CUSTOM&quot;</span> &nbsp;
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> tcCharList
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE10&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> Just Digits
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcDigits
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE16L&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> Hexadecimal <span class="kw2">in</span> <span class="kw2">lower</span> <span class="kw1">case</span>
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcDigits <span class="sy0">+</span> <span class="st0">&quot;abcdef&quot;</span>
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE16&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> Hexadecimal <span class="kw2">in</span> <span class="kw2">upper</span> <span class="kw1">case</span>
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcDigits <span class="sy0">+</span> <span class="st0">&quot;ABCDEF&quot;</span>
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE26L&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">Lower</span> <span class="kw1">case</span> letters
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> <span class="kw2">LOWER</span><span class="br0">&#40;</span>lcLetters<span class="br0">&#41;</span>
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE26&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">Upper</span> <span class="kw1">case</span> letters
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcLetters
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE36L&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> Digits <span class="sy0">+</span> <span class="kw2">Lower</span> <span class="kw1">case</span> letters
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcDigits <span class="sy0">+</span> <span class="kw2">LOWER</span><span class="br0">&#40;</span>lcLetters<span class="br0">&#41;</span>
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE36&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> Digits <span class="sy0">+</span> <span class="kw2">Upper</span> <span class="kw1">case</span> letters
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcDigits <span class="sy0">+</span> lcLetters
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE52&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> <span class="kw2">All</span> letters
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcLetters <span class="sy0">+</span> <span class="kw2">LOWER</span><span class="br0">&#40;</span>lcLetters<span class="br0">&#41;</span>
<br /><span class="kw1">CASE</span> tcCharSet <span class="sy0">==</span> <span class="st0">&quot;BASE62&quot;</span> 
<br />&nbsp; &nbsp; <span class="sy0">*</span> Digits <span class="sy0">+</span> <span class="kw2">All</span> letters
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcDigits <span class="sy0">+</span> lcLetters <span class="sy0">+</span> <span class="kw2">LOWER</span><span class="br0">&#40;</span>lcLetters<span class="br0">&#41;</span>
<br /><span class="kw1">OTHERWISE</span>
<br />&nbsp; &nbsp; <span class="sy0">*</span> The <span class="kw3">same</span> <span class="kw2">as</span> BASE10
<br />&nbsp; &nbsp; lcCharList <span class="sy0">=</span> lcDigits
<br /><span class="kw1">ENDCASE</span>
<br /><span class="kw2">RETURN</span> lcCharList</pre></td></tr></tbody></table></div><p>
</p><p><strong>Ornekler</strong>
<br />* Rollover to min value (Base10)
<br />? NextKey(&quot;999999&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; 000000
</p><p>* Next value (Base16)
<br />? NextKey(&quot;999999&quot;, &quot;Base16&quot;)&nbsp; &amp;&amp; 99999A
</p><p>* Dash (&#039;-&#039;) has not been changed
<br />? NextKey(&quot;999-FFF&quot;, &quot;Base16&quot;)&nbsp; &amp;&amp; 99A-000</p>]]></description>
			<author><![CDATA[dummy@example.com (soykanozcelik)]]></author>
			<pubDate>Sun, 07 Mar 2010 19:53:07 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1563/alphanumeric-key-incrementing-routine/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[Gülmece.]]></title>
			<link>http://www.fox4um.com/topic/1560/gulmece/new/posts/</link>
			<description><![CDATA[<p>Soykan abiden <img src="http://www.fox4um.com/img/smilies/smile.png" width="15" height="15" alt="smile" />
</p><p>4 yaşında başarı donuna işememektir
<br /> 12 yaşında başarı arkadaş bulabilmektir 
<br />&nbsp; 16 yaşında başarı araba sürebilmektir
<br />&nbsp; &nbsp;20 yaşında başarı seks yapabilmektir
<br />&nbsp; &nbsp; 35 yaşında başarı para kazanabilmektir
<br />&nbsp; &nbsp; &nbsp;50 yaşında başarı çok para kazanabilmektir
<br />60 yaşında başarı seks yapabilmektir
<br /> 70 yaşında başarı araba sürebilmektir
<br /> 75 yaşında başarı arkadaş bulabilmektir
<br /> 80 yaşında başarı donuna işememektir</p>]]></description>
			<author><![CDATA[dummy@example.com (ugurlu2001)]]></author>
			<pubDate>Sat, 06 Mar 2010 08:14:35 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1560/gulmece/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[max sorunum]]></title>
			<link>http://www.fox4um.com/topic/1559/max-sorunum/new/posts/</link>
			<description><![CDATA[<p>CREATE Cursor sayi (ckod c(10))
</p><p>INSERT INTO sayi(ckod) VALUES (&quot;6999&quot;)
<br />INSERT INTO sayi(ckod) VALUES (&quot;6998&quot;)
<br />INSERT INTO sayi(ckod) VALUES (&quot;61000&quot;)
<br />INSERT INTO sayi(ckod) VALUES (&quot;61001&quot;)
</p><p>select max(ckod) as sonuc from sayi into cursor enbuyuk
</p><p>sonuc=&quot;6999&quot;
</p><p>oysa ben &quot;61001&quot; elde etmek istiyorum</p>]]></description>
			<author><![CDATA[dummy@example.com (metin)]]></author>
			<pubDate>Fri, 05 Mar 2010 12:59:15 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1559/max-sorunum/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[SQL moving avarage - çok güzel]]></title>
			<link>http://www.fox4um.com/topic/1558/sql-moving-avarage-cok-guzel/new/posts/</link>
			<description><![CDATA[<p>özellikle firma performans ölçümlemeleri için (bence) mükemmel bir sql örneği.
<br />(moving avarage hep bana çok şey anlatmıstır)
<br /><a href="http://www.sqlservercentral.com/articles/Moving+Average/69389/">http://www.sqlservercentral.com/article &#133; age/69389/</a></p>]]></description>
			<author><![CDATA[dummy@example.com (cetinbasoz)]]></author>
			<pubDate>Thu, 04 Mar 2010 11:05:56 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1558/sql-moving-avarage-cok-guzel/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[excel hücreleri ile ilgili]]></title>
			<link>http://www.fox4um.com/topic/1134/excel-hucreleri-ile-ilgili/new/posts/</link>
			<description><![CDATA[<p>excele aktarılan bilgiler düzenlenirken, bir hücrenin alignment özelliği nasıl değiştirilir bulamadım. left right yada center olması? birde belli aralıktaki hücrelere kenarlık çizmek istiyorum. ince kenarlık, kalın kenarlık nasıl çizdirebilirim. şimdiden teşekküler...</p>]]></description>
			<author><![CDATA[dummy@example.com (cetinbasoz)]]></author>
			<pubDate>Wed, 03 Mar 2010 15:26:24 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1134/excel-hucreleri-ile-ilgili/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[Windows Server 2003'e Runtime]]></title>
			<link>http://www.fox4um.com/topic/1557/windows-server-2003e-runtime/new/posts/</link>
			<description><![CDATA[<p>merhaba arkadaşlar
<br />vp9 hazırladığım programı Windows Server 2003&#039;e Runtime yüklediğim zaman kullanıcılar programı çalıştıramıyor ancak ve ancak foxpro yüklediğim zaman sorun çözülüyor. VP9 RTS windows server&#039;e yüklenirken bilmediğim birşey mi? var kurmam yeterli olmuyormu?</p>]]></description>
			<author><![CDATA[dummy@example.com (ugurlu2001)]]></author>
			<pubDate>Wed, 03 Mar 2010 08:06:54 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1557/windows-server-2003e-runtime/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[peşpeşe rapor nasıl olur yardım?]]></title>
			<link>http://www.fox4um.com/topic/1556/pespese-rapor-nasil-olur-yardim/new/posts/</link>
			<description><![CDATA[<p>15 sene evvel foxpro2.6 for dos ile bir .prg yazdım 8 tane report varımdı .lq300 yazıcıya farklı boyutta&nbsp; &nbsp;ve farklı sayıda report gönderirdim. peşpeşe bazen 100 bazen 120 bazen 200 satır olurdu._padvanc=linefeed ve store prow() ile hangi satır da olduğumu&nbsp; bulup 33 kesme yerine eject yapıp iş bitmiş olurdu ..prgimi çök iyi vfp9 ile yazdım ama iş yazıcıya gelince her report bir sayfada ve sayfa sonu beyaz olur .aman.diye&nbsp; hepsini bir&nbsp; reportta grub grub topladım şimdi peşpeşe olur ama her sayfa sonu 4 satır boş&nbsp; kalır ve benim reportum peşpeşe özelliğini elden verir yardım edersiniz memnun kalırım .kagıdım rol dur ve 33 satır ıle kesilebilir</p>]]></description>
			<author><![CDATA[dummy@example.com (melany)]]></author>
			<pubDate>Wed, 03 Mar 2010 05:56:14 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1556/pespese-rapor-nasil-olur-yardim/new/posts/</guid>
		</item>
		<item>
			<title><![CDATA[sql database için hangi pşanı önerirsiniz ?]]></title>
			<link>http://www.fox4um.com/topic/1554/sql-database-icin-hangi-psani-onerirsiniz/new/posts/</link>
			<description><![CDATA[<p>çok kayıt almasını beklediğim 2 tablom var.
<br />program içerisinde sürekli 2.tabloya kaydedilmemiş 1. tablo sorgusu yapıyorum.
</p><p>2 ayrı mimari kullanabilirim, hangisini öneririsiniz ?
</p><p>A. 
<br />tablo1 -&gt; id_alan, bilgi_alan
<br />tablo2 -&gt; id_alan, bilgi_alan 
</p><p>SELECT * FROM tablo1 WHERE tablo1.id_alan NOT IN (SELECT tablo2.id_alan FROM tablo2)
</p><p>B. 
<br />tablo1 -&gt; id_alan, bilgi_alan, işlem_tamam (bit)
<br />tablo2 -&gt; id_alan, bilgi_alan 
</p><p>SELECT * FROM tablo1 WHERE işlem_tamam = 0 
<br />-----
<br />sorgu her seferinde (yıllık her iki db de ayrı ayrı 1.500.000 kayıttan) 100-200 arası sonuç döndüreceğini düşünüyorum. bit olarak alan eklenmesi halinde de yılda 2MB yük olacak gibi 
</p><p>aklıma gelen B planı hız için db ye gelecek 2MB yükü gözardı etmek gibi&nbsp; 
<br />A planının hızlı daha hızlı olabileceğini düşünüyorum, ne kadar fark eder ?</p>]]></description>
			<author><![CDATA[dummy@example.com (metin)]]></author>
			<pubDate>Tue, 02 Mar 2010 09:48:38 +0000</pubDate>
			<guid>http://www.fox4um.com/topic/1554/sql-database-icin-hangi-psani-onerirsiniz/new/posts/</guid>
		</item>
	</channel>
</rss>
