I am lead to believe that you may not be subscribed, so I will copy you
directly.
Disclaimer: I have no ability to do anything with VB, I run Linux and do
not own VB.
I will attempt to add some pointers inline and here to get you started.
You may find some useful materials here:
http://www.pitonyak.org/database/
The real find is here, however:
http://www.oooforum.org/forum/viewforum.phtml?f=10&sid=5a14fbee2b02592b9e3421ce0b138d34
There is a sticky post at the top with some excellent samples by Drew
Jensen; his material is amazing.
Sapper wrote:
I was looking at your site. I would like to know if I could create a) database,
Yes, see the links above, you can indeed create a database.
then b) Connect data from a VB6 Form to fill that database,
I do not believe that you will be able to directy tie VB6 database, but
rather, would need to access an OOo Base document using the UNO API. You
would then need to write VB code to extract the data that you want and
manually deal with your VB form. It might be easier to use an OOo form
directly so that some aspects of the data access can be provided
automatically.
the c) extract that data again to be used in a VB6 form.
Same as the answer above.
> If this this is possible can you send me a *sample* showing a) Database, b)
Two pieces of data TO the database from a VB6 Form, c) Extracting that data to be
used in VB6.
The level of work required for a volunteer that know all of the systems
very well would likely take hours and it might not be the best solution...
Can this be done by PLACING THE DATABASE in the same file as my compiled
program,
Uncertain, but doubtful since you require OOo and UNO to access the
database.
or does it have to be compiled with VB6? If so, how????
Again with the VB questions :-)
I am not really certain what you are asking here. based on the previous
answers, I think that this is also a no.
I have spent *much* time on this
Also, be certain to ask on the Base mailing list.
Can you illustrate building a database within your *own product* first?
There is much documentation on this I believe. Check out the
documentation project and the material from Andrew Jensen. My documents
demonstrate some simple database stuff in my AndrewBase.odt document.
Your inability to deal with VB6 may be a problem and therefore given to someone
who understands this - in terms of your product.
In general, the OOo people are not likely to actively use VB6 to access
OOo. It is done, but I usually see these types of questions in the macro
forums (such as the macro forum on OOoForum as listed above, and on the
dev mailling list).
I'm sorry this was directed to the wrong person.
The Base mailling list would be better; probably. You are asking for
many things that you desire to integrate that are not likely to
integrate well. Each portion requires a different area of expertiese.
i was merely asking for a *small snipet*,
If there was direct integration from a VB form to a Base document, it
might be small. The major problem here is that you can not access an OOo
Base document using something like ODBC or JDBC. If this was possible
(and I wish that it was), then your question would have been as simple
as "How do I connect to a base document using ODBC" and then the rest
would have been a pure VB question best asked elsewhere. It would be
nice if this capability were added. Time, all it takes is time.
So please do not persume something NOT intended at all.
That would be boring; much more fun to assume things :-)
The original replier provides a lot of help and spends many hours
helping others. He probably recognized the many hours required to
produce the small snippets that you desire. I assume that you will need
to change some portion to significantly lower the required effort to
solve this problem. For example:
* Do not use OOo as the back end because you can not access it directly
using external tools through ODBC.
* Do not use VB Forms, but rather, use forms included with OOo.
If you have no knowledge of this, then please pass this on to someone who can
understand the qusetion and the INTENT.....Thank you.
He has no ability to do this. This is merely a mailling list where
users, such as yourself, subscribe and answer questions because they
like to do so.
You will find more specific database expertiese on the database mailing
list.
I suggest that you download OOo, and read the manual and how-to's in the
documentation project and try to get started. Then, when you encounter a
difficulty, ask us to help you out with a specific problem.
Good advise. Now if only I had more links than what I already provided,
I know that there are more...
http://documentation.openoffice.org
I thought I was talking with a group that *understood* this product......namely
the *developer of that product*..........
That would be on the dev mailling list. Well, really, there is a dba-dev
and a dba-users mailing list. I see a few developers on both lists, but
this is more of a "how do I use this product" question so if my answer
is not sufficient, be certain to try the dba-users mailling list.
Yes, thank you. I certainly understand who created VB6. They were the ones who directed me to you, and they were the ones that suggested I ask you this question.
I remember looking up a word in the dictionary. They used a word that I
did not know, so I looked up that word, which refered me back to the
first word. :-)
Thank you for informing me that you use Linx, but what does this have to do with a) Your product, and b) with the question I asked.
He is indicating that he has no ability to comment or test anything with
VB6.
I have recieved numerous direct requests that I try certain things using
.NET, VB, etc. To avoid these direct requests, I usually mention that I
use Linux at home and can not try them.
Please send this on to one that *understands* what I am asking.......Thank you.
You are very polite. I appreciate this!
What list are you talking about? Can you provide this list? Thank you.
Was my answer sufficient for the dba-users and dba-dev mailling lists?
I was looking for links to the mailling lists, and I found this (which
is not the mailing lists, but interesting):
http://support.openoffice.org/index.html
Sorry that I can not provide more information at this time...
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
