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

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

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

add a comment

0

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

Ratslinger

19388 ●8 ●32 ●108

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

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

add a comment

0

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

Newcomer
1 ●1 ●1 ●2

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

Comments

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 ( 2017-02-10 04:38:02 +0200 )edit

add a comment

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

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

Comments

Question Tools

Stats

Related questions

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

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

Comments

Question Tools

Stats

Related questions

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

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