Re: Help with RichEdit and CLOB Oracle filed
- From: "tuzai" <yaxiyakun@xxxxxxxxxxxx>
- Date: 22 Jun 2005 23:30:55 -0700
"Jim Fleming" <jfleming@xxxxxxxxxxx> wrote:
>Hi!
>Would anyone have some short code snippet(s) that show how to:
> 1) Pass the contents of a RichEdit (RTF formatted) into a Stored Procedure CLOB field.
> 2) Pass the contents of a CLOB query field into a RichEdit for display purposes.
>Both operations using Delphi 7, Oracle 9i and Oracle Oledb Provider.
>
>We would be grateful for any help, as it would help us get started.
>
>Thanks,
>Jim Fleming
>
>
Hi, Jim, the problems can be workrounded,but not use stored procedure:
1). with ADOQurey.params.parambyname('clob_column') do
begin
datatype := ftMemo;
value := Richedit.lines.text;
end;
2). var
temp: widestring;
begin
ADOQry.SQL.Text := 'select ' +
'* from table1 ' + 'WHERE dbms_lob.instr(content, ''' +
key + ''', 1, 1) > 0';
ADOQry.Open;
while not FQry.Eof do
begin
Temp := FQry.FieldByName('Content').Value;
RichEdit.lines.add(temp);
FQry.Next;
end;
end;
3).But still have a problem,you can't insert the Non-Ansi characters to the clob column, eg Chinese character. I don't
know how to solve it.
4). Hope it can help you!
.
- Prev by Date: Re: TADOTable Error without persistent fields
- Next by Date: Anyone know how to insert the Chineses Character into the Clob (oracle)?
- Previous by thread: Row level locking when using ADO Query
- Next by thread: Anyone know how to insert the Chineses Character into the Clob (oracle)?
- Index(es):
Relevant Pages
|
