OOBase and LOBs

janpla · General User Joined: 04 Feb 2006 Posts: 7

Is there a way to represent LOBs (large objects) in a form? Or any way to enter/retrieve them from the database, that interfaces nicely with a form?

DrewJensen · Posted: Tue Feb 14, 2006 10:56 am Post subject:

Well, if it is a Memo field cLOB or an image file bLOB then yes.

There is an image control and a text box can be tied to a memo field and set to multi-line display.

In the example database I listed at the top of the forum I show how to work with both of these. The form wizard will not place either of these correctly, but it is very easy to do so by hand.

Drew
_________________
Blog - http://baseanswers.spaces.live.com/

janpla · General User Joined: 04 Feb 2006 Posts: 7

Gret - thanks a lot!

janpla · General User Joined: 04 Feb 2006 Posts: 7

I tried creating a simple table in Oracle:

create table ex(
id number primary key,
descr clob
);

- then I created a form with those two columns - the ID field is a number control, and the descr is a multiline text control. I can enter data in both fields, but when I move to the next row only the ID field is saved; the descr is just blanked out. Altso, I noticed it isn't possible to set the limit on the text control very high - certainly not as high as what you can enter in a clob in Oracle.

Am I doing it wrong?

DrewJensen · Posted: Mon Feb 20, 2006 11:43 am Post subject:

well, I did not have oracle on this machine so could not test against it..

I have lots of past Oracle experience however, so went an grabbed a copy of the express engine..I'll see if I can figure out what is going on.
_________________
Blog - http://baseanswers.spaces.live.com/