The following message was posted to the OOo Forum:
http://www.oooforum.org/forum/viewtopic.phtml?p=390589
I repeat the message here:
**
I am working with OpenOffice basic, HSQlDB 2.0.
I have a table for attachments in my DB.
When i upload a File that is big for example 32 MB
Frank Schönheit - Sun Microsystems Germany wrote:
Hello Andrew,
Insert an image control into a form and associate the control to a field
in the database.
The image control has a specific size. If the control displays an image
with a different aspect ratio, then the image may be severely
Fernand Vanrie wrote:
Andrew Douglas Pitonyak wrote:
Hi Andrew I have some questions
Insert an image control into a form and associate the control to a
field in the database.
Is the Image datafile stored in the database or is het just the URL of
the image
I store the image
Insert an image control into a form and associate the control to a field
in the database.
The image control has a specific size. If the control displays an image
with a different aspect ratio, then the image may be severely distorted.
Any thoughts on how to avoid this?
My primary thought
Would closing the connection have sufficed?
If not, what is the difference between closing a connection and
disposing of a connection?
andrew wrote:
Marc Santhoff wrote:
BUT - ah ha I found the bug..it was my code - well, maybe not.all my
code.
I did not dispose of the connection within
Ariel Constenla-Haile wrote:
(Down-)Loading a picture (from) into a DB
Hy there! I need some help with the following:
I'm trying to load and download pictures from databases (both embedded
and external data sources like MySQL) using the API with OOoBasic.
I have a complete example of this
I thought that this was fixed in OOo 2.01, but it is still a problem. I
created an issue against this. Was I mistaken?
The problem is that Windows holds a Base document open. You need to
entirely close OOo, including the quick starter, or you can not delete a
Base document on Windows. I saw
Wolfgang Schaible wrote:
hi Andrew,
Am Montag 07 November 2005 06.33 schrieb Andrew Douglas Pitonyak:
Function FindComponentWithURL(sURL As String, bLoadIfNotFound As
Boolean) Dim oDocs ' Enumeration of the loaded components.
Dim oDoc' A single enumerated component.
Dim sSt
I use the following code snippet to open a form from a Base document.
oBaseContext = CreateUnoService(com.sun.star.sdb.DatabaseContext)
oDataBase = oBaseContext.getByName(sDBURL)
oDBDoc = oDataBase.DatabaseDocument
oFormDef = oDBDoc.getFormDocuments().getByName(sFormName)
oDummyFormDef =
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew,
I tried
oTables = oCon.getTables()
oTables.refresh()
This did not work
This is surprising, since it's exactly what the Controller does with its
own connection when you dispatch the URL ...
Ciao
Frank
I will
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew,
I tried
oTables = oCon.getTables()
oTables.refresh()
This did not work
This is surprising, since it's exactly what the Controller does with its
own connection when you dispatch the URL ...
Ciao
Frank
Initially,
Ocke Janssen wrote:
Hi,
Wolfgang Schaible wrote:
hi,
Am Sonntag 30 Oktober 2005 02.57 schrieb Andrew Douglas Pitonyak:
I load a Base document.
I add a table using a macro (and the API).
The Base document shows the new tables.
If my macro uses SQL to create the table, then the tables
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew,
You got me there I have not tried this on my Linux computer, only on
a Windows XP Professional computer. I have noticed that on Windows, if a
Write document is open, I can not attach it to email. It is probably the
same
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew,
I will perform some more complete checks and come up with a minimal set
of steps to reproduce the problem. I am using macros, which means that I
am using a database context to get the database. I then obtain a
connection. I
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Wolfgang,
Sounds good, but
running a macro (with Base-Doc not open), how can I obtain
a controller of the document and dispatch the command
.uno:DBRefreshTables ?
Ocke's last sentence
Normally it should be enough to query
Wolfgang Schaible wrote:
hi,
Am Sonntag 30 Oktober 2005 02.55 schrieb Andrew Douglas Pitonyak:
If I open a Base document and then close it, I can not delete the
file. I need to exit OOo before I can delete the file. Is there
anyway that I can really close the connection to the database
If I open a Base document and then close it, I can not delete the file.
I need to exit OOo before I can delete the file. Is there anyway that I
can really close the connection to the database?
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Book:
I load a Base document.
I add a table using a macro (and the API).
The Base document shows the new tables.
If my macro uses SQL to create the table, then the tables are not
visible unless I close and re-open the document. Is there anyway to tell
OOo to refresh its view of things from a macro?
Marc Santhoff wrote:
Hi,
I'm diggin to the new things in the base module and it's api:
The form wizard shows how to create a new form from an url, it creates a
temporary writer doc and inserts it in the DocumentDefinition wich in
turn is inserted into the Forms container.
What I'd like to do
a report,
add in doc properties
save it,
then save the base document
reopen the report
the doc properties have been removed - is this a bug?
Cheers
Richard
On Saturday 22 October 2005 06:00, Andrew Douglas Pitonyak wrote:
Pere Castanyer Sarda wrote:
-BEGIN PGP SIGNED MESSAGE
changed and not being a programmer, and not having any
knowledge of Java, I am honestly limited to following prescribed steps.
Thanks again
Yannis
O/H Andrew Douglas Pitonyak έγραψε:
Γιάννης Παπαδόπουλος wrote:
Hello,
I would like to ask help concerning some problems I encounter with
BASE
Γιάννης Παπαδόπουλος wrote:
Hello,
I would like to ask help concerning some problems I encounter with BASE.
-When I import a My Sql db through ODBC it takes a long time to to
load the tables and sometimes it crushes, greek characters are not
displayed although the encoding of the source is
Because, so far, 100% of the people I've personally encountered who told me
RDBMSes can't handle 'unstructured data' had little or no experience in
relational database design. Probably there are exceptions, but from my
perspective the very phrases unstructured data and semi-structured
data
Thanks!
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew,
'oFormDoc = oFormDef.execute(sOpenMode, nCmd, eEmpty) ' Variable NOT
defined
'oFormDoc = oFormDef.execute(sOpenMode, nCmd, oNull) ' Object
Variable NOT set
'oFormDoc = oFormDef.execute(sOpenMode, nCmd, NULL) '
24 matches
Mail list logo