Ask Your Question

trueriver's profile - activity

2019-01-25 03:58:17 +0100 received badge  Famous Question (source)
2018-12-03 15:45:52 +0100 received badge  Famous Question (source)
2018-08-23 14:54:18 +0100 received badge  Notable Question (source)
2018-08-23 13:32:28 +0100 edited question mysql relationships not shown till exit and re-enter Base

mysql relationships disappear in LO Base hi, still with base connecting to a MySQL database, I can't get relationships (

2018-08-23 13:30:47 +0100 edited question mysql relationships not shown till exit and re-enter Base

mysql relationships disappear in LO Base hi, still with base connecting to a MySQL database, I can't get relationships (

2018-08-23 13:29:15 +0100 answered a question mysql relationships not shown till exit and re-enter Base

In LO 5.2.7.2 connecting to MySQL 8 using JDBC the new relationships are created but not visible until exit from Base an

2018-08-23 13:26:51 +0100 edited question mysql relationships not shown till exit and re-enter Base

mysql relationships disappear in LO Base hi, still with base connecting to a MySQL database, I can't get relationships (

2018-08-23 05:29:51 +0100 received badge  Popular Question (source)
2018-08-22 20:35:37 +0100 asked a question mysql relationships not shown till exit and re-enter Base

mysql relationships disappear in LO Base hi, still with base connecting to a MySQL database, I can't get relationships (

2018-08-21 16:41:04 +0100 marked best answer auto increment with MySQL

hi, when creating a table in design view in the embedded datbase, it is straightforward to get a primary key that auto-increments. You fill in the key name, select integer (integer), and a yes/no box appears in the lower part of the screen for auto-increment.

The same does not seem to happen when attempting the same in MySQL, whether connected to a localhost database or over the internet. In both cases I am connecting using JDBC with the Oracle recommended connector.

I can create an auto incrmement field by connecting to the mysql database using the mysql client.

I am not clear if I am doing something wrong, forgetting something, or whether this is a gap in the Oracle JDBC class.

=======

Edit 20th Aug: Additional detail

If I open a table created from the mysql cli that has an autofield, the <autofield> value shows on new records and this works normally and shows <autofield> in the relevant "cell", as your screenshot shows.

However, when I edit that table and select the row defining that field, the Autovalue drop down never appears.

If I make any change to that field, it loses its AutoField attribute.

If I copy & paste the table the copy loses the autovalue.

If Base offers to create a new PK for the copy table, the checkbox for AutoValue is greyed out. Altogether it seems clear that Base is not communicationg this fact to the underlying database.

My Base is version 5.2.7.2 and is using Oracle Java 1.8.0.181 so when I downloaded the connector it seemed sensible to use mysql-connector-java8.0.11.jar

When I instaled it, I did the "Test Class" and it seemed to load OK (but then I know it partly works...)

Do you recommend I change to the java.5.1 connector?

If so, should I also downgrade the Java runtime that was installed before I consciously did anything to choose a JRE?RE does your Base use?

And if so, how would I downgrade the runtime? I am worried that other things in my OS might depend on Java 8 if I do downgrade it...

ON the other side of the argument, there is something clunky going on here ... I can get Firebird, FlameRobin, and MySQL running ish, but none of them in a fully featured way.... the common factor seems to be the JRE as the respctive connectors are different.

I did wonder if the difference was caused by using a local connection rather than the net, but I can't get AutoValue to work on a test/demo server running the latest MySQL version at db4free.net

In the meantime the work-around is to create those tables using the cli. For production work that is what I would do anyway; for prototyping I prefer to use a GUI to tweak things and test variations....

R~~

2018-08-21 16:40:53 +0100 commented answer auto increment with MySQL

I will put my problem with auto-increment on a new table down to my using an earlier version of Base than you (we discus

2018-08-21 15:43:39 +0100 commented answer auto increment with MySQL

I will put my problem with auto-increment on a new table down to my using an earlier version of Base than you (we discus

2018-08-21 15:06:12 +0100 received badge  Notable Question (source)
2018-08-20 17:09:22 +0100 edited question auto increment with MySQL

auto increment with MySQL hi, when creating a table in design view in the embedded datbase, it is straightforward to get

2018-08-20 17:06:06 +0100 edited question auto increment with MySQL

auto increment with MySQL hi, when creating a table in design view in the embedded datbase, it is straightforward to get

2018-08-20 10:40:52 +0100 received badge  Popular Question (source)
2018-08-20 01:27:48 +0100 received badge  Notable Question (source)
2018-08-19 19:56:35 +0100 asked a question auto increment with MySQL

auto increment with MySQL hi, when creating a table in design view in the embedded datbase, it is straightforward to get

2018-08-07 07:52:01 +0100 commented answer connect base to firebird(server) - how??

what permissions do you have on the following directories, please? /var/lib/firebird /var/lib/firebird/3.0 /var/lib/f

2018-08-07 07:50:24 +0100 commented answer connect base to firebird(server) - how??

what permissions do you have on the following directories, please? /var/lib/firebird /var/lib/firebird/3.0 /var/lib/f

2018-08-07 07:48:53 +0100 commented answer connect base to firebird(server) - how??

what permissions do you have on the following directories, please? /var/lib/firebird /var/lib/firebird/3.0 /var/lib/fir

2018-08-07 07:32:14 +0100 commented question running LO with a local non-embedded database under Qubes OS

hi Ratslinger The question relates to the interaction of LO, FlameRobin, and the Qubes OS and is therefore of possible

2018-08-06 23:38:43 +0100 received badge  Popular Question (source)
2018-08-06 23:38:42 +0100 received badge  Popular Question (source)
2018-08-06 18:55:36 +0100 commented answer connect base to firebird(server) - how??

regarding Jaybird. I am using Jaybird 3.0.4 as that was the one that is designed to work with the relevant version of t

2018-08-06 18:48:10 +0100 edited answer connect base to firebird(server) - how??

This is PARTLY an issue with file permissions or locations. Qubes does clever stuff to make sure system changes roll bac

2018-08-06 18:41:47 +0100 edited question connect base to firebird(server) - how??

connect base to firebird(server) - how?? Reading a previous answer, I now understand that from LO 6.2 onwards Base will

2018-08-06 18:36:54 +0100 received badge  Notable Question (source)
2018-08-06 18:36:13 +0100 asked a question running LO with a local non-embedded database under Qubes OS

running LO with a local non-embedded database under Qubes OS Hi, I have been having problems trying to get Firebird run

2018-08-06 14:51:49 +0100 commented answer connect base to firebird(server) - how??

thanks for the headsup on this. So that means HSQLDB v1.8 for another LO point release? (I am guessing nobody will feel

2018-08-06 14:47:24 +0100 commented answer DATEADD (or similar) in calculated field in view (embedded db)

Thanks for this answer, depressing though it is... I agree with your preferred solution as the most professional soluti

2018-08-06 14:46:31 +0100 commented answer DATEADD (or similar) in calculated field in view (embedded db)

Thanks for this answer, depressing though it is... I agree with your preferred solution

2018-08-06 14:44:41 +0100 marked best answer DATEADD (or similar) in calculated field in view (embedded db)

hi

I want a drop down to select one of the eight days from one week ago till today.

So I created a table with the integers 0..7 in column N, and tried to create a view with the calculated column subracting N from today's date. I have used today() - N AS WKDATE to do the similar in Ms Access.

Is this possible in base with the embedded db? I cant find a syntax that the view builder will accept.

If this technique is not possible, any suggestion about how I would create such a drop down box that automatically shows today's date and the previous seven dates?

2018-08-06 14:43:45 +0100 received badge  Popular Question (source)
2018-08-06 11:14:21 +0100 edited question base: keep alive setting

base: keep alive setting hi again eveyone Is there a setting in base (or elsewhere in LO) to specify the maximum time b

2018-08-06 11:02:07 +0100 asked a question base: keep alive setting

base: keep alive setting hi again eveyone Is there a setting in base to specify the maximum time between sending packet

2018-08-02 13:44:04 +0100 asked a question reconnect base to db after failed connection

reconnect base to db after failed connection hi everyone Is there a menu item to force base to reconnect to a remote da

2018-07-31 15:14:39 +0100 answered a question connect base to firebird(server) - how??

I am guessing this is an issue with file permissions or locations. Qubes does clever stuff to make sure system changes r

2018-07-31 14:44:49 +0100 edited answer select into cached -- does it create a permanent table?

I got it working eventually - had the INTO clause in the wrong place, despite trying several guesses. SELECT ... INTO .

2018-07-31 14:38:46 +0100 answered a question select into cached -- does it create a permanent table?

I got it working eventually - had the INTO clause in the wrong place, despite trying several guesses This version of my

2018-07-31 03:51:18 +0100 received badge  Famous Question (source)
2018-07-31 03:00:00 +0100 commented answer connect base to firebird(server) - how??

I STILL can't get this to connect, and a close to abandoning this :( FireRobin connects OK, and I created a user and pa

2018-07-31 02:43:12 +0100 commented answer connect base to firebird(server) - how??

I STILL can't get this to connect, and a close to abandoning this :( FireRobin connects OK, and I created a user and pa

2018-07-31 01:41:39 +0100 received badge  Enthusiast
2018-07-30 23:51:40 +0100 commented answer connect base to firebird(server) - how??

Qubes is not a normal distro. It runs several semi-autonomous VMs under Xen for security enhancement. I do not understan

2018-07-30 23:51:40 +0100 received badge  Commentator
2018-07-30 11:36:08 +0100 commented answer connect base to firebird(server) - how??

I was approximating a bit: its actually Qubes, which is itself based on Debian but lags some months behind Debain stabl