The Business of Love

That's what I think about Sunday Marriage Show (officially translated as, We Got Married) aired on MBC, a Korean TV, that i found accidentally on youtube. I watch the whole 29 episodes marathonly, oftenly at night, after returning from lovely office. Andy-Solbi is my favorite ^_^

Who doesn't like love topic? even the most saddest person in earth can stand the topic if his favorite entertainer is presenting it. Moreover, it was fun and informative for me. Have been watching many western TV programs for 12 years, this Korean show, made me informed that they have bowing tradition when meeting their elders. They traditionally sit on the floor, sleep as well. They traditionally consider eye contacts as awkward. And they have current issues of foreign wives and children all over the country, mostly from Thailand, Vietnam, and else where (i forgot). The show itself stands differ from similar western show with not forcing so many inappropriate physical contact on screen. Not to mention their born-to-be-shy stereotypes, haha.. So entertaining and refreshing when compared to western's born-to-be-confident, kekekke.

tonight's reminder is ..

that everyday is His bless of healthiness and worshipness
that being alive is to feel all of emotions, ups and downs
thanks for reminding me God ^_^

Hmmm (2)

now that i think about it, we made each other real...
really, because of you guys, i'm real...
take your time, because i'm okay...

Shinhwa - Run

*pingsan karena kata perpisahan yang terlalu keren* :D

RFC_READ_TABLE Lagi

Perjuangan panjang mempersolid function RFC_READ_TABLE yang dipersembahkan secara tidak niat oleh SAP masih berlanjut. Setelah menuruti SAP notes yang melahirkan RFC_READ_TABLE perjuangan, hasil download untuk record bertipe Numeric yang punya digit di belakang koma akhirnya tidak menghasilkan karakter * lagi. Tapii.. misalnya di tabel nilainya 3.146.349.951,26, maka yang saya dapat adalah 3.146,349,95126. Angka macam apa itu.. huhu. Dengan niat mulia mempercepat solusi dan berbekal keyakinan bahwa field tersebut di SAP didefinisikan selalu memiliki 2 digit di belakang koma - maafkanlah saya wahai para BPSTI penerus yang akan memaintain program2 kami - saya putuskan mengambil nilai itu sebagai String, melenyapkan semua koma dan titik teu puguh, meng-convert-nya menjadi tipe Double, dan mengalikannya dengan 0.01. Anyone knows proper solution? Welcome.

Rumah Maya Saya Berantakan

Gara-gara pake template custom yang gambar-gambarnya di hosting gratisan... giliran gambarnya udah ga tersedia, meranalah rumah maya saya. Sebenernya sudah ngerasa kalo template yang coklat ini kurang nyaman. Makanya saya coba-coba template lain di sini. Ketemu template bagus, yang pink itu, tapi masih males ngecat si coklat ini, jadi dipending. Eh, sekarang pas di longok, gambarnya hilang hiks hiks. Apa hosting sendiri aja ya... trus beli domain? Keurus gak yah...

Hmmm

Sepertinya saya memang tidak punya bakat untuk jadi programmer. Yang bikin saya bertahan sampai hari ini jadi begini lebih karena keukeuh nggak mau mengecewakan rekan kerja... Tetap bertahan begini cuma akan memakan waktu saya lebih banyak di tempat kerja. Tapi kalo ga jadi programmer, saya mau kerja apa ya?

Antisipasi Time Out dengan Cara Barbar

Hari ini berhadapan dengan time out SQL Server, yg bikin program saya melempar eksepsi dan berhenti melakukan tugas mulianya, mendownload ratusan ribu PO dari SAP untuk web reporting. Time out delete statement.

delete from sap_mseg where mblnr in (select mblnr from sap_mkpf where status = 'NEW')

Apa akal?

For i = 0 To 1000
delete from sap_mseg where mblnr in (select TOP 1000 mblnr from sap_mkpf where status = 'NEW')
End For

Tau dimana salahnya? TOP 1000 itu membuat record yang di select itu-itu aja, kemungkinan besar sudah di delete di looping pertama. Dan looping kedua sampai ke 1000 akan menghasil 0 records affected. Selanjutnya?

For i = 0 To 1000
delete TOP (1000) from sap_mseg where mblnr in (select mblnr from sap_mkpf where status = 'NEW')
End For

Lalu untuk mengantisipasi looping 1000 kali masih menyisakan record yang belum terdelete:

delete from sap_mseg where mblnr in (select mblnr from sap_mkpf where status = 'NEW')

Barbar ya? Ga ped..

All the Talks

Talking creates technicalities. Doing eliminates them.

Jadi gitu...