"Pake SelectBlob companylogo into :docblob where .. trus di-set p_1.Setpicture(docblob)
-----Original Message----- From: gde bahagia [mailto:[EMAIL PROTECTED] Sent: Friday, April 08, 2005 12:52 PM To: [email protected] Subject: RE: [indopb] Mohon Bantuan Cara Save OLE Database Blob 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 ----------------------------------------------- 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/
