Ask Your Question

BASE : Impossible to edit data via forms! [closed]

asked 2017-02-09 20:11:46 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

On base I connected an SQLite database with a jdbc driver. I can see and modify data (insert, delete or update) with the table data editor but can do neither with a form (the data are invisible and cannot be accessed...). Can so help me please?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Newcomer
close date 2017-02-10 04:21:13.522561

2 Answers

Sort by » oldest newest most voted

answered 2017-02-09 21:28:01 +0100

Ratslinger gravatar image

updated 2017-02-09 21:32:31 +0100

Don't have much experience w/SQLite (least favorite) but I do know it works. Have it on Xubuntu and for this test installed LO v5.2.3.3. Using ODBC driver hear but from others (see this post for non-related problems: click here) JDBC also works. Here is a working form:

image description

Have no problems with adding or modifying data through table or form.

Originally set this up with LO v5.1.4.2 so I don't believe LO is the problem.

Also, I use LO versions from LibreOffice and not "distro" versions.

edit flag offensive delete link more

answered 2017-02-10 04:15:04 +0100

Newcomer gravatar image

Thanks a lot ratslinger. I've spent some time installing and configuring an odbc driver for my database, to see if it'd work as it does for you. And even though I can't see a reason why a form would react differently than the main base document depending on the choice of the driver, well ... it actually does. With an ODBC driver, forms now work correctly with my database!

edit flag offensive delete link more


Glad it's working. Keep in mind it could be just that specific JDBC connector. Like other DB usually there are different ones around.

Ratslinger gravatar imageRatslinger ( 2017-02-10 04:38:02 +0100 )edit

Question Tools

1 follower


Asked: 2017-02-09 20:11:46 +0100

Seen: 80 times

Last updated: Feb 10 '17