Trick of maintaining table Friday, Feb 22 2008

For some reason, client would extend or add one or more field in your current table, and actually the data have already there. What I’ve done here was, I have a temporary field when I was creating the table. Example,

2 Responses »

 

The different between char and varchar Friday, Feb 22 2008

At a glance, varchar and char are not quite different, aren’t they? but actually, they have a critical different that you must attend of it. First, the theory is varchar will remove all space (blank) character either behind or ahead of string, but char is not. Okay maybe you will think, actually it doesn’t need, does it?

If you will not join the 2 characters, it doesn’t matter whether you will use either varchar or char, but how about If I have this condition. I’d like to extend my string variable, but actually the data have already there. This extend variable also will update to related table. What should I do? This one is one of the solution that you could apply. The solution should be provide user field in your table, let’s say, user1, user2, user3, this one is solomon’s standard table design.

I create a buffer who will merge the current field with the user field. Let’s say, my current field is 30 characters length, and I’d like to extend it become 60 characters, so I will use the 30 characters length user field.

When I’d like to load the buffer again, my code should be this one

bbuffer.LongName = bxTable.CurrentField + bxTable.User1, and in my stored procedure, I’ll update the related table by this code,

select @CurrentField = CurrentField, @User1 = User1
from xTable
where ……

update table
set name = @CurrentField + @User1
where ……..

if your @CurrentField and @User1 datatype are varchar, and let’s say the value of @User1 is ‘ text text’, and the value of @CurrentField is ‘header front’, so when you merge it, the merge string will be ‘header fronttext text’, it should be ‘header front text text’.

It’s dangerous, isn’t it?

The first one (’header fronttext text’) will happen if I’m using varchar data type, and the last one will happen if I’m using char data type.

So, be careful to apply the data type.

No Responses »

 

What do you think about Indonesia? Thursday, Feb 21 2008

My client was coming from Singapore yesterday, and I was just asked her what do you think about Indonesia? She said, whuaaa

First, Everyone in here always late, they don’t fulfill their promise on time

Second, Everything must be signed to confirm

Third, So messy

Last, I don’t like the food, I’d like to escape from Indonesia

Actually, she came to Jakarta while Jakarta was in rainy season, so everybody here was late because of flood, second, Indonesians have many cheater, so you have to be careful while make a transaction (so you have to sign to confirm), third, your country is a small country, so it should your country is richer than Indonesia, the last one, what kind of food ha? I like any kinds of food except pork or anything without halal label, or maybe I’m an omnivore, hahaha.

5 Responses »

 

Programmer is a laborer ? Friday, Feb 15 2008

Honestly, when I was college I was told that being a programmer is not a main goal of computer science. What they told were the main goal was being an analyze. Awal kuliah sih percaya” aja, tapi begitu sekarang terjun ke industri langsung, it’s not the truth. Actually the concept is an old concept. Nowadays, analyze and code are doing by a person and it’s called technical/programmer. What If I’d like to be a PM (Project Manager)? You shouldn’t join computer science if you’d like to be PM. If it’s possible, it needs time to be Project Manager since they need more experience as developer system.

So do you still believe that Programmer is a laborer?

Sebagai contoh, coba liat programmer” di Microsoft atau Oracle. Who invent the solution?The answer is the old one. Who invent the new technology? The answer is the old one. Who invent design pattern? The answer is the old one. All invention will be the same answer, the old one. Jadi, pemahaman kalo uda tua ga mau jadi programmer, it’s also the miss.

Sebenernya saya juga masih menganut “uda tua ga mau jadi programmer” :), but my boss told me that code is an art. You could build your own character by seeing your code. Then kepuasan menjadi programmer itu adalah saat mampu memecahkan solution on client site. You look wonderful in your client sight. Saya masih berpikir apakah pemahaman saya salah karena IT sendiri di Indonesia sungguh tidak dihargai bukan hanya IT, pendidikan di Indonesia masih belum dihargai dengan baik. So, what I invent, what I explore and luckily it will become the great invention, the government just don’t care. Berbeda situasi dengan negara-negara di luar sana. Contoh kasus ya Nelson Tanu, dy menjadi rekor professor termuda di Amerika, darimana itu orang asalnya ? Indonesia. Pemerintah sama sekali don’t care. Padahal dy sudah ditawari untuk menjadi warga negara Jepang, Iran, dsb, karena apa? Jepang ingin mengakui bahwa dy mempunyai warga negara yang wonderful in education, Indonesia ? you may burst of laught.

So, kesimpulannya, Programmer is not a laborer. Saat orang tahu bahwa kamu seorang programmer, you will be honored by that person. Saya mengalaminya waktu saya ditanya sama dokter waktu saya berobat, she told that wow, you’re the great one, you’re so young, you could develop more than what you expect. See ? Cuma pas ditanya, kamu lulusan mana ? ITB ya? saya bilang IPB? dy teriak wow lebih keras lagi :)). dan seperti biasa, kalimat sakti itu keluar “SAYA BARU TAHU IPB ADA ILMU KOMPUTER”

7 Responses »

 

Some cheats for mobile phone’s games Thursday, Feb 14 2008

Hhmmm…Actually I found this in my forum and I’d like to write it here so that I couldn’t forget

Have a nice try

2006 Real Football 3D
Cheat Mode - On Menu Screen, press 0417, then press * while playing, pause the game for more cheat option

2006 Real Football
Cheat Mode -> On Menu Screen, press 0417, then press * while playing

America’s Army: Special Operations
Unlock Everything - On Menu Screen, press Up *360
Full Health - While playing, press Up *3715
Maximum Power - While playing, press Up *372
Complete Mission - While playing, press Up *379

2 Responses »

 

Setbutton property in Ms Solomon 7.0 sp1 Thursday, Feb 14 2008

It’s funny, I have just found that help in version 7.0 sp1 wasn’t updated. Actually in the previous version, setbutton function was called by this one.

Call setbutton(InsertButton + SaveButton + DeleteButton, LEVEL0, FALSE)

but in version 7.0, the variables have changed become this one.

Call setbutton(TbInsertButton + TbSaveButton + TbDeleteButton, LEVEL0, False) 

In Solomon’s help there are still using first variable the same as previous person. What a miss

No Responses »