Hi :)
If you have been able to recover or re-create your file then i think the
problem is pretty much solved isn't it? It's an unlikely event so i'm not sure
whether it's worth posting a bug-report about it.
The 2nd link of these 2 is probably the best one for you for this case
omega
The
Omega sector
America's Last
Line of
Defense
*How do I check for duplicates in a data base using another data base ?
*
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
Hi,
I have an rainfall.ods document that has 24 tabs. Two of the tabs
contain figures and the balance contain graphs of the figures.
I recently experienced a problem, it would seem after my last tab
addition, that prevents me from creating a PDF file of the selected
sheets(12).
The PDF
Am 28.07.2012 14:17, Lynne Stevens wrote:
omega
The
Omega sector
America's Last
Line of
Defense
*How do I check for duplicates in a data base using another data base ?
*
SELECT A.*
FROM A JOIN B ON A.ID = B.ID
returns all rows from table A with an equivalent ID in table B.
--
What is you OS?
Windows, Linux, Mac? Which version.
What version of LO are you using? Your statement of using 3.3 since
3.4.5 is confusing. Are you using 3.5.5, 3.5.4, 3.5.3?
while someone tries to figure out the issue, if you use Windows, please
download doPDF - free PDF printer
omega
The
Omega sector
America's Last
Line of
Defense
*That sounds like they will be merged ! . . They are to remain separate
and the B file is to be used for a mailing thing after it has the
duplicates removed . . the mailing thing I have figured out and what
fields/columns to use
omega
The
Omega sector
America's Last
Line of
Defense
*Don't you have the ability to print to a PDF file ? Linux gives me the
choice to print the file or print to a PDF file and asks where to save
it and a name for it . . You must be a windows user LOL ! I really feel
sorry for
El 28/07/12 15:42, Hylton Conacher (ZR1HPC) escribió:
Hi,
I have an rainfall.ods document that has 24 tabs. Two of the tabs
contain figures and the balance contain graphs of the figures.
I recently experienced a problem, it would seem after my last tab
addition, that prevents me from creating
Hi :)
Database programs are a front-end that read the data that is stored in a
database back-end.
Trying to simplify things a bit so this is not entirely accurate ...
With Writer, Calc etc you save a file in a certain format. Then a variety of
programs can open that file. With a database
Le 28/07/12 14:17, Lynne Stevens a écrit :
Hi Lynne,
*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 ?
Comment inline:
Lynne Stevens wrote:
omega The Omega sector America's Last Line of Defense
*That sounds like they will be merged ! . . They are to remain
separate and the B file is to be used for a mailing thing after it
has the duplicates removed . . the mailing thing I have figured out
and
On Sat, 2012-07-28 at 08:35 -0700, Lynne Stevens wrote:
omega
The
Omega sector
America's Last
Line of
Defense
*That sounds like they will be merged ! . . They are to remain separate
and the B file is to be used for a mailing thing after it has the
duplicates removed . . the
Windows users can get free PDF printer drivers, like doPDF. Linux users
can use other options like CUPS-PDF. What are you using to print your
files to PDF with?
We what to encourage Windows users, and to tell them they are stupid to
use it. I know of many people who cannot use Linux due
I'm running LO on Ubuntu 12.04. I've used all previous versions of LO
through the present 3.5.5.3. My experience with export to pdf is that
the entire file is exported. It does not work to select one page or a
certain selection on a page. If I want to print just 1 page of a
multipage document
On 7/28/2012 11:40 AM, Lynne Stevens wrote:
I really feel sorry for windows users ROFLMAO
Don't start that. I used Linux from the earliest days. (0.94 Kernel and
SLS Linux). I now use W7 and there is nearly nothing I could do in
Linux that I cannot do in Windows easier. I do use Firefox and
I do the following with my browser printing:
Print the web page to a PDF document - since you cannot choose pages -
and then open up the PDF document and choose wich page to print out.
I do that type of printing most often with ALL of my packages that can
print to a printer physical
omega
The
Omega sector
America's Last
Line of
Defense
*I really do not care what format it is in as long as it does the job
and when I am done with the file I save it back to the same format it
was in ! !*
*As it is not my file and Thomas is a windoes user person NOT a computer
An example of an inner join:
table1 INNER JOIN table2 ON table1.foreign key=table2.primary key
Mathematically the following seems to be possible:
table1 INNER JOIN table2 ON table1.foreign key=2*table2.primary key
Is the latter also an INNER JOIN? There seems to be other possible
omega
The
Omega sector
America's Last
Line of
Defense
*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
omega
The
Omega sector
America's Last
Line of
Defense
*Oh yeah both files are CVS and are the way Thomas downloads them but
being he is not to computer literate and most likely does not know he
can save it in different ways . . No telling . . I ask one time and he
said that is how
Am 28.07.2012 22:03, Lynne Stevens wrote:
omega
The
Omega sector
America's Last
Line of
Defense
*Ok Thomas downloads 2 Data bases ( CVS format ) he wants to remove
Duplicates from Data Base B using Data base A and THEN Data Base A gets
deleted when done
*
OK, that is
$ cat fileA.csv
Not sure who asked the original question, nor what OS you're on but...
If you're using Linux and the files are in fact text files (CVS) as
indicated below, then I would think something to the effect of:
cat file1 file2 file3 | sort | uniq uniqueRecords.txt
Might do part of the trick. I
omega
The
Omega sector
America's Last
Line of
Defense
*Hey that sounds good to me I will have Thomas bring over a set of the
files
and I will use it . . will make Thomas jump up and down and happy
*
On 07/28/2012 01:28 PM, Andreas Säger wrote:
Am 28.07.2012 22:03, Lynne Stevens
2012/7/28 Andreas Säger ville...@t-online.de:
Am 28.07.2012 22:03, Lynne Stevens wrote:
omega
The
Omega sector
America's Last
Line of
Defense
*Ok Thomas downloads 2 Data bases ( CVS format ) he wants to remove
Duplicates from Data Base B using Data base A and THEN Data Base A
On 07/28/2012 03:42 PM, Lynne Stevens wrote:
omega
The
Omega sector
America's Last
Line of
Defense
*Oh yeah both files are CVS and are the way Thomas downloads them but
being he is not to computer literate and most likely does not know he
can save it in different ways . . No telling . .
On 07/28/2012 03:36 PM, Dan wrote:
An example of an inner join:
table1 INNER JOIN table2 ON table1.foreign
key=table2.primary key
Mathematically the following seems to be possible:
table1 INNER JOIN table2 ON table1.foreign
key=2*table2.primary key
Is the latter also an INNER
On 28-07-12 19:34, webmaster-Kracked_P_P wrote:
Windows users can get free PDF printer drivers, like doPDF. Linux users
can use other options like CUPS-PDF. What are you using to print your
files to PDF with?
large cut
For everybody who needs to use for some reason Windows:
use VMware (or
On 28-07-12 19:49, David B Teague sr wrote:
On 7/28/2012 11:40 AM, Lynne Stevens wrote:
I really feel sorry for windows users ROFLMAO
Don't start that. I used Linux from the earliest days. (0.94 Kernel and
SLS Linux). I now use W7 and there is nearly nothing I could do in
Linux that I cannot
I just recently got Libreoffice after having used openoffice for quite awhile,
and after i transferred the documents over and everything, sometimes i open my
documents and huge chunks of the text are invisible and there is no rhyme or
reason to getting them to show up again.
omega
The
Omega sector
America's Last
Line of
Defense
*I dump it off to a HP Laser jet 1522 something and it prints like crazy
has fax, Printer. copier, and scanner all in one thing
I got it for free seems the office has windows and the driver got lost
and the printer would not work
omega
The
Omega sector
America's Last
Line of
Defense
*Since it has the recorder office number ( column A ) on the line of all
the John Kings and if the number is the same it will be deleted but if
not and there are two different John's and it has a different recorders
office number
On Sat, 2012-07-28 at 15:36 -0400, Dan wrote:
An example of an inner join:
table1 INNER JOIN table2 ON table1.foreign key=table2.primary key
Mathematically the following seems to be possible:
table1 INNER JOIN table2 ON table1.foreign key=2*table2.primary
key
Is the latter
32 matches
Mail list logo
