Hi :)
Errr, is it possible to switch the auto-save and auto-backups off for
a while and see if that improves things? The thing i find difficult
about doing that is remembering to save properly and frequently
enough. With Base i think it's also important to close properly.
There is some
Hi :)
Errr, are you using the internal back-end? You haven't connected to
an external back-end have you? You should really be keeping your data
in an external back-end instead of having the whole database as a
single file.
Being able to do that is one of the main things that makes Base so
much
Hi :)
I tend to have auto-save off or set at much longer intervals.
Generally i tend to find that it takes almost no-time to re-type or
re-do anything that took under 20mins to do the 1st time around and
often there is an improvement 2nd time around anyway. Also i find it
really frustrating to
Hi :)
There is also the idea that you can create a Writer document that acts
as a form or a report. Opening the Writer document only shows the
front-end. I think it can't be used to enter data but is good for
just using and accessing the data.
Regards from
Tom :)
On 14 January 2014 23:32,
I use custom styles in Conditional Formatting. For example, I highlight cells
that contain values that are more than 2.5 standard deviations on either side
of the mean value of the data.
I am unable to delete styles that I no longer need or to change their
characteristics (e.g. background
Highlight the area, then Format Clear Direct Formatting.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org/Editing-Custom-Styles-in-Calc-tp4092310p4092325.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
At 04:48 15/01/2014 -0800, James E Lang wrote:
I use custom styles in Conditional Formatting. For example, I
highlight cells that contain values that are more than 2.5 standard
deviations on either side of the mean value of the data. I am unable
to delete styles that I no longer need or to
Le 14/01/2014 22:42, Ryan Ashley a écrit :
Hi Ashley,
In MS Access you can select a startup form that will open when the
database file is opened. You can also hide all of the development stuff
(buttons, toolbars, etc) when said form opens so it appears to the end
user as an application. How
I used to have that problem. It seems to have stopped around about 16th July
2013. Not sure why!
Either -
I upgraded LibreOffice which stopped the feature
or I did something else which I can't remember!
I'm currently on 4.1.4.2.
Alex
On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote:
Le 15/01/2014 04:30, rost52 a écrit :
Hi,
Is below statement only valid for a Mac or also for a PC with XP?
This is my experience on Mac over the different versions of LO from
3.3.0 to present, and having moved through Snow Leopard to Lion to
Mountain Lion and now Mavericks.
I have seen
In Access I can runn a passthrough query to execute SQL commands on a
true DB server. Is this possible in Base? I have a MariaDB server and
want to use Base to create forms for accessing it, but need to run SQL
commands to encrypt and decrypt certain data, so linking the tables
won't work.
I have a project for which I need to extract data that is in a .sql file
(presumably a SQL database). I've done very little with SQL so I need
some guidance on doing this. One route would be to open it with Base or
Access (I now finally have access to MSAccess on a Windows machine but
would
SQL files are normally SQL scripts which are backups or scripts that
create a database on a SQL server. If you need something in that script,
you would need to setup a MySQL server, execute the SQL file on that
server, and then get the data out that you need. I know that is a
mouthful, and the
On 01/15/2014 10:51 AM, Carl Paulsen wrote:
I have a project for which I need to extract data that is in a .sql
file (presumably a SQL database). I've done very little with SQL so I
need some guidance on doing this. One route would be to open it with
Base or Access (I now finally have
Carl ,
Use a mySQL database and connect over the Native Connector
then google for the book DataBase Programming writen by Roberto
Benitez for Openoffice but also for LibreOffice
a lot of code can been found on the Book-website
Greetz
Fernand
On 15/01/2014 16:55, Ryan Ashley wrote:
SQL
Having said all that. It would appear that I've never had auto backup switched
on.
Having switched it on I now see backups and autobackups for writer and calc
documents. Nothing at all for base documents.
Alex
On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote:
I used to have that
Not sure if this got to the list
Alex
On Wednesday 15 Jan 2014 16:46:24 you wrote:
Having said all that. It would appear that I've never had auto backup
switched on.
Having switched it on I now see backups and autobackups for writer and calc
documents. Nothing at all for base documents.
Le 15/01/2014 16:51, Carl Paulsen a écrit :
Hi Carl,
An SQL file does not necessarily need to contain data, it could
contain just a set of instructions for the database engine to execute.
The SQL file is not a database as such, it is a generally text file
containing instructions that a SQL db
Le 15/01/2014 16:14, Ryan Ashley a écrit :
Hi Ryan,
In Access I can runn a passthrough query to execute SQL commands on a
true DB server. Is this possible in Base? I have a MariaDB server and
want to use Base to create forms for accessing it, but need to run SQL
commands to encrypt and
Thanks, Jay, that is VERY helpful and clarifies a lot. I wondered if I
needed the server setup but lots of things I read yesterday suggested I
did need that. I do understand that things like Base and Access are
just GUIs, but I guess I really just don't understand what a database is
and, in
Carl
SQL is the query language used by relational databases and there is
ANSI/ISO standard specification for the SQL. So, in principle, any
relational database should understand vanilla SQL. Generally, this is
true. HSQL (Base backend), Jet (Access), Oracle, MySQL/MariaDB,
PostgreSQL, and
Thanks again, Jay. Because of my long-time familiarity with Filemaker,
Access, Salesforce (and Base soon I hope), I'm well aware of the
structure of a relational database. And I'm pretty sophisticated user
and even developer so long as the backend is hidden from me (LOL).
Now I have this
Sent to just Alex T by mistake:
On 1/15/14 1:41 PM, Carl Paulsen wrote:
OK, this is VERY helpful.
I decided to try reading the file in a text editor and that was
instructive! The file is about 13MB, and from a quick read through,
the vast majority seems to be actual data in a kind of
Below is an excerpt from the file referring to the donations_money
table. Obviously there are some ID fields, donation info fields
(Amount, Date, etc.), a primary key field, etc. Immediately after the
table, there's the dump of all the data in that table. I've only
included one or two
Carl,
Depending on the program (this looks like the output from MySQL
Workbench) and the tables are MySQL/MariaDB - the MyISAM is specific
MySQL/MariaDB database engine. If you have MySQL or MariaDB and MySQL
Workbench installed you can import/restore the data.
The second dump has the data
Le 15/01/2014 22:08, Carl Paulsen a écrit :
Hi Carl,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
This is enough to tell us that the data came from a mysql database
originally. MyISAM is the default engine for non-transactional MySQL
databases :
http://en.wikipedia.org/wiki/MyISAM
In the sample
That is not what I need. When I push a button on a form, I need some SQL
statement(s) to be sent to the server. Is this possible?
On 1/15/2014 1:04 PM, Alex Thurgood wrote:
Le 15/01/2014 16:14, Ryan Ashley a écrit :
Hi Ryan,
In Access I can runn a passthrough query to execute SQL commands
Hi :)
Is it likely to be possible to connect Base directly to the original
data? So that instead of getting an export or a dump of the data it
can be read dynamically?
I know it is not what the o.p. is asking for but i often wonder.
Regards from
Tom :)
On 15 January 2014 22:03, Alex Thurgood
Hey Ryan,
You could write some Basic code and link it to the button.
On 01/15/2014 06:57 PM, Ryan Ashley wrote:
That is not what I need. When I push a button on a form, I need some SQL
statement(s) to be sent to the server. Is this possible?
On 1/15/2014 1:04 PM, Alex Thurgood wrote:
Le
Tom,
The initial format and some of the data types would need to be converted
so the syntax matched to the new . This is a well known problem when
migrating from one SQL database to another where there are added,
non-standard data types.
Jay
On 01/15/2014 05:12 PM, Tom Davies wrote:
Hi :)
So, are you using Apache OpenOffice (AOO) or LibreOffice (LO)? I only
ask because you posted to the LO group about a bug you reported in
AOO Not that I have not done similar things given that I subscribe
to both mailing lists.
On 01/15/2014 12:56 AM, James E Lang wrote:
Related bug
Le 16/01/2014 00:57, Ryan Ashley a écrit :
That is not what I need. When I push a button on a form, I need some SQL
statement(s) to be sent to the server. Is this possible?
Only via a LO Basic macro or a script (python, java, JS, REXX), the
push-once and fire functionality you're
Unfortunately, I don't know what causes the problem and, thus, I can't
recreate it.
I am trying something now. I brought it up, updated a record but did
not save it (I have a saved copy someplace else). I intend to let it be
up overnight and check in the morning for the files. I had
33 matches
Mail list logo
