below is a shortened version of some code using Oracle's long raw in conjunction with
RTE for storing chart notes. I am using pb 6.5 and Oracle 7.x
blob lbb_note
string ls_text
string ls_patient_id
integer li_seq
long ll_row
// clear contents of rtf_chart
rte_chart.displayonly = false
rte_chart.SelectTextAll()
rte_chart.Clear()
rte_chart.displayonly = true
ll_row = dw_chart.GetRow()
li_seq = dw_chart.GetItemNumber( ll_row, "seq")
SELECTBLOB note
INTO :lbb_note
FROM Chart
WHERE patient_id = :is_patientid and
seq = :li_seq
using sqlca;
ls_text = string(lbb_note)
if isnull(ls_text) then
ls_text = ""
end if
// paste chart text into the header of the RTF for viewing
rte_chart.displayonly = false
ll_word_count = rte_chart.PasteRTF(ls_text)
rte_chart.displayonly = true
"Pandalai, Sathya" wrote:
> Hi All,
> I have a problem with retrieving a database field in oracle which is
> of LONG RAW type. Could anyone tell me as to which variable i should use in
> powerbuilder for this purpose. I tried BLOB, ULong and Long in PB and all
> gave the same error "inconsistant data types". I am using an embedded SQL to
> fetch data. I am using PB ver 7.0 and Oracle ver 7.4. My OS is Win 95.
> Anyone with some suggestions please reply. If i need to do anything more
> also please tell me.
>
> Many Thanks and Warm Regards
>
> Sathya Pandalai
> SAGA SWAT Team
> 188, Broadway,
> Woodcliff Lake, NJ - 07675-1232
> USA
> Telephone : (201)-505-4355 (O)
> e-mail : [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
> ----------------------------------------------------------------------------
> ---------------------------------
> The person who is swimming against the stream knows the strength of it.
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **********************************************************************
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
