kalau kaya gini ? Select sum( CDBL( left(Total_Hours, len(Total_Hours) -4) )) from Transaksi
Thanks Ronald Irawan http://www.Foodinvestment.com/?id=ronald_delgeano Jakarta Tustadi I Made <[EMAIL PROTECTED]> 21/02/2007 08:27 To [email protected] cc Ronald Irawan <[EMAIL PROTECTED]> Subject Keluar Error ----> Tanya coding untuk menghitung type data varchar 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] All New Yahoo! Mail – Tired of unwanted email come-ons? Let our SpamGuard protect you. [Non-text portions of this message have been removed]
