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:
http://docs.yahoo.com/info/terms/
