Insert an image in Base tabl

[JZA]

Hi anyone  know the process to insert an image in database table?

--
Alexandro Colorado
Co-Lead OpenOffice.org ES
http://es.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[ooo-2]

Hi,
Alexandro Colorado a écrit :
> Hi anyone  know the process to insert an image in database table?
>

Have you looked oooforum.org ?

May be this topic can help you ?

http://www.oooforum.org/forum/viewtopic.phtml?t=60152

You can see other post by http://www.oooforum.org/forum/search.phtml 
with "insert an image in database"

Other links :
http://user.services.openoffice.org/en/forum/viewtopic.php?f=39&t=5912&p=28195&hilit=+insert+image+image#p28195
http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=5872&p=27499&hilit=+insert+image+image#p27499

What do you want to do ?
What is your problem exactly ?

Francois


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Alexandro Colorado]

> What do you want to do ?
> What is your problem exactly ?
>
> Francois


Hi, what I need is to have a form to be able to upload an ID pic of the record.

Your answer seemed to be for a programmer. I need an end user solution
so we can have a form as:
- Name
- Last name
- Age
- Picture
...

Picture most be stored in the table as a binary (longbinary).

--
Alexandro Colorado
OpenOffice.org Español
IM: jza@...

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Manuel NAUDIN]

Hi,

2008/7/21 Alexandro Colorado <jza@...>:
> Hi anyone  know the process to insert an image in database table?
in
http://www.pitonyak.org/database/AndrewBase.pdf
there's a chapter 2 : Storing Images (Binary Data) in base which has a
step by step example of creating the base and the form.
>
> --
> Alexandro Colorado
> Co-Lead OpenOffice.org ES
> http://es.openoffice.org
Manuel

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Drew Jensen-2]

Alexandro Colorado wrote:

>> What do you want to do ?
>> What is your problem exactly ?
>>
>> Francois
>>    
>
>
> Hi, what I need is to have a form to be able to upload an ID pic of the record.
>
> Your answer seemed to be for a programmer. I need an end user solution
> so we can have a form as:
> - Name
> - Last name
> - Age
> - Picture
> ...
>
> Picture most be stored in the table as a binary (longbinary).
>
>  

Well, you have already received the answer on the list here, but to
emphasize it from the 'End Users' perspective.

( Meaning with no use of scripting of any kind, just the built in GUI )

[hmm- sorry if this message arrives twice, I am testing TB3 today and it
is being a bit persnickety )

Anyway - back to images.

The only support for inputing an image, via the GUI, is with the Image
Control.
The control is found on the 'More Controls' toolbar, this toolbar is
accessible only from the 'Form Controls' toolbar.
Image Controls are not added to forms in the Form Wizard, you must add
them explicitly.
The image control supports a context menu ( right mouse click ) with the
menu item 'Insert Graphics from', this calls a file open dialog box.
The file open dialog box can also be opened by double clicking the mouse
on the Image Control.

Using the Image from your database.
You can display images on a form, again with the Image Control.
You can use images in reports created with the Sun Report Builder(tm)

Now, to the best of my knowledge that is it - no further support for
images in base - without the use of scripting.

Hope that helps...

Drew


--
OpenOffice.org User Community Forums
Connecting users around the globe!
  Community forum  http://user.services.openoffice.org/en
  Communauté francophone  http://user.services.openoffice.org/fr
  Közösségi fórum  http://user.services.openoffice.org/hu
  コミュニティーフォーラム  http://user.services.openoffice.org/ja

United States PostgreSQL Association: http://www.postgresql.us/


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[JZA]

On Thu, 24 Jul 2008 09:34:13 -0500, Drew Jensen  
<drewjensen.inbox@...> wrote:

> Using the Image from your database.
> You can display images on a form, again with the Image Control.
> You can use images in reports created with the Sun Report Builder(tm)
>
> Now, to the best of my knowledge that is it - no further support for  
> images in base - without the use of scripting.
>
> Hope that helps...
>
> Drew
>
>

Thanks Drew, I heard that you need to assign the field (on the table) as  
longvarbinary is that correct?


--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[JZA]

I was able to register the image object but I wasn't able to get the  
images shown on the report.

On Sat, 26 Jul 2008 11:52:56 -0500, Alexandro Colorado  
<jza@...> wrote:

> On Thu, 24 Jul 2008 09:34:13 -0500, Drew Jensen  
> <drewjensen.inbox@...> wrote:
>
>> Using the Image from your database.
>> You can display images on a form, again with the Image Control.
>> You can use images in reports created with the Sun Report Builder(tm)
>>
>> Now, to the best of my knowledge that is it - no further support for  
>> images in base - without the use of scripting.
>>
>> Hope that helps...
>>
>> Drew
>>
>>
>
> Thanks Drew, I heard that you need to assign the field (on the table) as  
> longvarbinary is that correct?
>
>

--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Drew Jensen-2]

Alexandro Colorado wrote:
> I was able to register the image object but I wasn't able to get the
> images shown on the report.
>

Hello Alexandro,

That doesn't sound quite right, in fact it sounds quite wrong. It sounds
as if what you did was to insert an object in the report file, and as
you have learned that is not supported.

Just to be sure we are on the same page here then
- there is no support for image fields (LongVarBinary fields) in reports
made with the original Report Wizard in Base.
- Image field support is only available with the SUN Report Builder(tm)
(SRB) extension. [Note - this will be changing, I believe with the final
release of 3.0, when a new report wizard will be introduced which
creates SRB style reports - this feature is not yet available in any
development snapshot builds however.]

So - if you have installed the SRB extension and you select 'Create
report in design', then selected your table with the image field as the
report's source you will find the image field available in the 'Add
field' window. Simply drag the field to the report and you are good to go.

HTH

Drew


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[JZA]

ok will have to download SRB and report back. Thanks for clearning this  
out.

On Sun, 27 Jul 2008 12:24:13 -0500, Drew Jensen  
<drewjensen.inbox@...> wrote:

> Alexandro Colorado wrote:
>> I was able to register the image object but I wasn't able to get the  
>> images shown on the report.
>>
>
> Hello Alexandro,
>
> That doesn't sound quite right, in fact it sounds quite wrong. It sounds  
> as if what you did was to insert an object in the report file, and as  
> you have learned that is not supported.
>
> Just to be sure we are on the same page here then
> - there is no support for image fields (LongVarBinary fields) in reports  
> made with the original Report Wizard in Base.
> - Image field support is only available with the SUN Report Builder(tm)  
> (SRB) extension. [Note - this will be changing, I believe with the final  
> release of 3.0, when a new report wizard will be introduced which  
> creates SRB style reports - this feature is not yet available in any  
> development snapshot builds however.]
>
> So - if you have installed the SRB extension and you select 'Create  
> report in design', then selected your table with the image field as the  
> report's source you will find the image field available in the 'Add  
> field' window. Simply drag the field to the report and you are good to  
> go.
>
> HTH
>
> Drew
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>

--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...