Makasih Pa Abraar,
Maaf saya salah, ternyata ga ada masalah pada selectblob nya.
Tapi yang bermasalah adalah pada baris : ole_1.objectdata = ole_blob
Kenapa ya saya ga bisa memasukkan var blob yang didapat kedalam ole object ?
Mohon bantuan rekan2.
/////////////////////////////////////////////////
blob ole_blob
integer li_rtn,li_header
selectblob "dokumen"."dok_blob" into :ole_blob from "dokumen"
where "dokumen"."dok_nomor" = :is_dok and
"dokumen"."dok_revisi" = :ls_rev;
ole_1.objectdata = ole_blob
li_rtn = ole_1.activate(offsite!)
if li_rtn < 0 then
Messagebox("Dokumen Error","Isi dokumen kosong")
end if
Obja = OLE_1.Object.Application.WordBasic
obja.appminimize('Microsoft Word',1)
/////////////////////////////////////////////////
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL
PROTECTED]
Sent: Friday, October 06, 2006 10:28 AM
To: Syarief Amanullah
Subject: Re: [indopb] Field Blob
Hello Syarief,
SELECT BLOB blob_col into :lbl_gambar from XXXXX WHERE id = :id;
Untuk update : UPDATE BLOB xxx SET blob_col = :lbl_gambar WHERE id =
:id.
Untuk insert setauku tidak ada di embeded sql, kalau mau insert yang
pakai UPDATE BLOB itu.
Friday, October 6, 2006, 10:08:34 AM, you wrote:
>
> Dear all,
> Gimana caranya memanipulasi (select, insert dan update) field
> blob / image pada MS SQL Server dengan menggunakan embeded sql di PB
> Mohon pencerahannya.
> Thx.
>
>
>
--
Best regards,
abraar mailto:[EMAIL PROTECTED]
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
