Setelah saya jalakan program keluar pesan error sbb: The sum or average aggregate operation cannot take a varchar data type as an argument. Kenapa ?
Perlu saya sampaikan bahwa nama tabelnya ------> Transaksi kemudian nama Fieldnya Total_Hours Total_hoursnya berisi 2 jam 4 jam dst Jadi saya mau hitung angkanya saja yaitu menjadi 6 jam yang didapat dari 2 + 4 ----- Original Message ---- From: Ronald Irawan <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, 20 February, 2007 5:49:31 PM Subject: Re: [indoprog-vb] Tanya coding untuk menghitung type data varchar "Select sum(left(tablenya, len(tableny) -4) ) from tablenya" angka 4, di dpt dari spasi + JAM Mudah2xan bisa Thanks Ronald Irawan http://www.Foodinve stment.com/ ?id=ronald_ delgeano Jakarta Tustadi I Made <[EMAIL PROTECTED] co.uk> Sent by: indoprog-vb@ yahoogroups. com 20/02/2007 15:19 Please respond to indoprog-vb@ yahoogroups. com To Programmer-VB@ yahoogroups. com, indoprog-vb@ yahoogroups. com cc Subject [indoprog-vb] Tanya coding untuk menghitung type data varchar Teman2 minta tolong, saya mempunyai type database varchar. katakanlah isi tabelnya 2 jam, 6 jam, 10 jam gimana codingnya supaya akhirnya bisa hasilnya 18 jam yaitu didapat dari 2 jam + 6 jam + 10 jam. Tolong kasitahu contoh codingnya. Terima kasih. ____________ _________ _________ _________ _________ _________ _ New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes. http://uk.rd. yahoo.com/ evt=44106/ *http://mail. yahoo.net/ uk [Non-text portions of this message have been removed] ___________________________________________________________ Inbox full of unwanted email? Get leading protection and 1GB storage with All New Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html [Non-text portions of this message have been removed]
