Hai prenz … last post di taon 2010 nih… Karena ada kesibukan … (ngodink) hehehehe jadi ketemu deh permasalahan nya, dulu mah gak pernah terpikirkan gimana caranya untuk deleting record dengan subquerying … Subquerying biasanya dilakukan dengan select statement mulu kalo di mysql, nah sekarang kejadian deh pengen delete record dengan kondisi yang di subquerying [...]
Archive for the ‘Coderz’ Category
MySQL: Delete dengan Sub-Query Condition
Posted in MySQL - DeBe, tagged Coding, MySQL, Trick on November 19, 2010 | 5 Comments »
Number again in MySQL
Posted in MySQL - DeBe on December 22, 2009 | 3 Comments »
Dear All, Dah lama tak posting blog, ini postingan terakhir di tahun 2009, mudah – mudahan di tahun 2010 bisa lebih banyak memberikan informasi yang sedikit nyeleneh … Lagi, kita berbicara masalah SQL yang tentunya di MySQL, karena saya berkutat di MySQL, kalo DB yang lain ??? hmm… boleh juga kali ya… cuma harus belajar [...]
Delphi … Frame … whats going on ???
Posted in Delphi - Code Gear on October 6, 2009 | 1 Comment »
Dear All … You may create an application for GUI without MDI Form related due to has an animation when creating or resizing like maximize or minimize on it … but we have another tricky to reduce the animation on MDI Form … another posts … Now, we talk about Frame … Frame is inheritance [...]
Devex: Unbound and Bounded Image Data Aware ver. 2
Posted in Delphi - Code Gear, tagged Coding, Delphi, Trick on July 22, 2009 | 5 Comments »
Dear All, After we trying the previous technique, we have face the problem … But, Fortunately we found the way to change it and running smoothly … Change the step and you will find the (maybe) good solutions … but still have one problem when handling the big data aware … First alias ka hiji [...]
Devex: Bounded and Unbounded Image Data Aware
Posted in Delphi - Code Gear, tagged Coding, Delphi, MySQL on July 10, 2009 | 10 Comments »
Dear All, Met ketemu lagi dalam acara Delphi Coderz … Kemarin, ada dari temen bro @ImanD mengenai bagaimana memunculkan gambar bukan dari database saja, akan tetapi dari file juga, soalnya kita pengguna Developer Express Quantum Grid. Setelah membaca dan mengurai dari keterangan Knowledge Basenya Developer Express. Akhirnya bisa ditampilkan apa yang diinginkan … sebelumnya mah [...]
Crosstab or Whatever that said at MySQL …
Posted in MySQL - DeBe, tagged MySQL, Query, Statements, Trick on June 30, 2009 | 20 Comments »
Dear All, again MySQL again…hehehehe … simple trick from me that will save your time of work when you using looping in code … yeah code … in Delphi, VB, what ever you create the aplication. We will trying to create crosstab or whatever you will said … in MySQL … First, saya punya data [...]
When your MySQL Server make you headache …
Posted in MySQL - DeBe, tagged MySQL on June 10, 2009 | 12 Comments »
Dear all, met me again … Now, we will posting how to resolve when your MySQL Server make you headache … alias bikin sakit kepala dan mau pecah … karena MySQL menolak semua access dari all host and IP. Actually we don’t know what this happen persist, teuing kunaon tah … langsung begitu gag mau [...]
Ngitung balance lagiii ….
Posted in MySQL - DeBe on March 23, 2009 | 3 Comments »
Dear All readers, Back again with “Ngitung Balance” … Pada postingan dulu, saya melakukan perhitungan balance dengan menggunakan fitur yang ada FastReport dan silahkan baca disini untuk balance FastReport. Nah, sekarang bagaimana ngitung balance dengan menggunakan MySQL atau Single Simple Query ? Setelah sekian waktu mencoba, mengutak – mengatik … dan akhirnya ketemu dengan simple. [...]
MySQL Trick for auto-key on trigger
Posted in MySQL - DeBe, tagged Coding, MySQL, SQL on February 25, 2009 | Leave a Comment »
Dear All, Once again, MySQL make me headache to handle un-linked key that consist at temporary tables and this two table is manipulate by record-form model. This is a scenario : We’ve 2 table — simple table that want to inserting the key for linked between that tables, that the key from master table is [...]
MySQL Grouping Tips
Posted in MySQL - DeBe, tagged MySQL, Structured Query Language on February 16, 2009 | Leave a Comment »
Hai hai … friend … ada kasus dari temen nih, sempet keringetan karena gak ketemu jalan keluarnya, sehingga posting di forum. Jadi sebagai bahan arsip ajah, saya arsipkan dan siapa tahu ada yang membutuhkannya. Ini pure di MySQL : DROP TABLE IF EXISTS `tnama`; CREATE TABLE `tnama` ( `id` int(11) NOT NULL auto_increment, `NIK` varchar(10) [...]






