Kira2 kalo nyimpan gambar di database bisa makan space besar tidak ? Lebih baek image itu di luar atau di database ?
--- gde bahagia <[EMAIL PROTECTED]> wrote: > > Siang, > Pada Bapak Aryoko. > Saya sudah bisa melakukan seperti yang bapak > beritahukan. > Ada Pertanyaan lagi. > Saya menyimpannya dalam image data type di table > sql. > bagaimana cara melakukan retrieve data tersebut. > > Terima kasih sebelum dan sesudahnya. > > > Aryoko <[EMAIL PROTECTED]> wrote: > Type data image pd column datawindow object tidak > bisa di select. > Untuk bisa menyimpan type data blob sebaiknya anda > menggunakan Embedded > SQL > >> ex : >> INSERT > - insert object picture(p_1) pada window > object > - Create Computed Column ( SPACE(255) as > logoPict) > didatawindownya > u/n menampung path-nya > - GetfileOpenName(..) /u/n mendapatkan lokasi > path-nya > - Set ls_path ke logopict > > >> UPDATE > BLOB logoblob > - ls_comp = > dw_arg.getitemstring(dw_arg.getrow(),'companyid') > For I = 1 to RowCount > - FileOpen(...) > - FileRead(FileOpen(...),logoblob) > - File Close(FileOpen(..)) > - Update UsrCompany Set CompanyId > =:ls_comp..... > - UpdateBlob Set CompanyLogo = :logoblob > Where CompanyId > =:ls_comp > Next > > >> Untuk lebih jelasnya ente bisa liat di HelpPB > (UPDATEBLOB) > > > > > > -----Original Message----- > From: gde bahagia [mailto:[EMAIL PROTECTED] > Sent: Friday, April 08, 2005 8:55 AM > To: [email protected] > Subject: [indopb] Mohon Bantuan Cara Save OLE > Database Blob > > > Selamat Pagi, Semua. > > Begini saya ada problem ketika ingin update OLE > database blob, mohon > bantuannya. > > Pertama saya punya database (SQL SERVER) > nama table : UsrCompany > CompanyId Char(10) > CompanyName VarChar(20) > CompanyLogo Image > > Saya Membuat satu data window freeform yang > berisikan > 2 coloum (CompanyId dan CompanyName) dan 1 Ole > database blob untuk > membuka paint agar dapat memasukkan logo. > > OLE Database blob properties > ClientClass : DataWindow > ClientName : Logo > KeyClause :UsrCompany.Companyid = :CompanyId > ClientNameExpression :"Logo" > Table : UsrCompany > Large Binary / Text Col :CompanyLogo:Blob > OLE Class Desc : PBrush : PaintBrush Picture > > Sewaktu saya add kedalam window dan pada satu tombol > saya ingin melakukan save dengan > dw_company.update() > tetapi muncul pesan error seperti : > > Line 1: Incorrect syntax near '='. > No changes made to database. > UPDATEBLOB FROM UsrCompany WHERE > UsrCompany.Companyid = > > > Dari yang saya baca menyimpan BLOB harus dengan SQL > Sintak, bagi > kawan-kawan sekalian apakah ada yang tau caranya? > Mohon Bantuannya, Terima Kasih Banyak > > > > > --------------------------------- > Do you Yahoo!? > Read only the mail you want - Yahoo! Mail SpamGuard. > > [Non-text portions of this message have been > removed] > > > > ----------------------------------------------- > INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT > ----------------------------------------------- > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: > [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > > > > > ----------------------------------------------- > INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT > ----------------------------------------------- > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: > [EMAIL PROTECTED] > > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/indopb/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > [Non-text portions of this message have been > removed] > > > > ----------------------------------------------- > INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT > ----------------------------------------------- > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: > [EMAIL PROTECTED] > Yahoo! Groups Links > > > [EMAIL PROTECTED] > > > > > > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
