[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] Re: I have a question
- Subject: Re: [libreoffice-users] Re: I have a question
- From: Lynne Stevens <firstname.lastname@example.org>
- Date: Sat, 28 Jul 2012 12:37:57 -0700
- To: email@example.com
*There are 2 FILES / Data bases each one has the same number of columns 126 each has same information except in Column R which has a single letter denoting its status as to what kind of sale it is . . Like bank sale, for sale by owner, and for sale by a realestate place and so on !
*That seems strange as if you wanted information you would have to delete the duplicates
in any data base or it would grow by gobs . . I remember in WAY BACK time in Super Calc there was a way of doing it and it is not open to Libre-office Calc ? . . haha that was on a big 3.5 inch disk the entire program hahahaha went into windows 3.1 . . 500 years ago . .
On 07/28/2012 09:39 AM, Alexander Thurgood wrote:
Le 28/07/12 14:17, Lynne Stevens a écrit :
*How do I check for duplicates in a data base using another data base ?By "another data base", do you mean :
(a) another ODB file ?
(b) another type of database manager, e.g. Access vs Calc, or MySQL vs
Access, or even Access vs Access ?
(c) another table in the same ODB file or in the same database schema
managed by a unique database manager ?
(d) any or all of the above combined ?
As you can see, the possibilities belie what would appear to be a
seemingly simple question.
Andreas has answered (c) for you, i.e. where both tables are in the same
There is no simple way to compare the contents of 2 HSQLDB/ODB files,
other than extracting the contents from one and importing it into the
other as a temporary or new table and then comparing the table results
from within the single ODB file using a JOIN query.
As for (b) LO Base does not allow you to adress two separate database
schema as far as I know from within a single query. I heard tell once
that it might be possible with Access tables being read by LO if an ODBC
connection was being used, and this only would work on Windows. Not
having tried it, I can't say whether it is true or not.
If what you are aiming for is indeed cross-schema queries in order to be
able to compare, this has been a requested (and never implemented)
feature in OpenOffice.org for many years.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
|[libreoffice-users] I have a question||Lynne Stevens <email@example.com>|
|[libreoffice-users] Re: I have a question||Alexander Thurgood <firstname.lastname@example.org>|
- Prev by Date: [libreoffice-users] Other SQL question as it affects Base
- Next by Date: Re: [libreoffice-users] Re: I have a question
- Previous by thread: [libreoffice-users] Re: I have a question
- Next by thread: Re: [libreoffice-users] Re: I have a question