I have libreoffice base + sqlite 3 and in a form I have a table control where the data that I enter but do not allow me to go to a record that is not active within the table control, why is this? and when I do the program breaks and I get out of libreoffice.
(edit: activated screenshots)
Hello,
It appears there is something not set correctly in the form design. Would need a copy of the .odb, which form is the problem & description of table(s) involved. If this cannot be provided then a much more detailed explanation of this form is necessary to help resolve the problem.
@josefito Please do NOT use an answer (it is for response to original question only) for a response. Instead use a comment to the answer you are responding to.
To add an attachment, edit your original question & use the paperclip icon on the toolbar. You cannot attach .zip files. Only need what was asked for in my last comment.
I am working on a database FINCA.odb + sqlite3 obdc and when I perform control of tables (grid) within a forms it does not allow me to move freely within the control of tables and I exit the program, I do not know if I will have to make a macro or it will be because sqlite3 does not allow it, but in the consultations if I can move as I want and in the control of tables, why is this?
The operating system is window xp and windows 10
SQLITE 3 ODBC
how do I upload the zip file
Thank you
This error is already fixed in version 6.0.0.2
Thanks for everything
Hello,
First, here is some info on SqLite setup with LO (actually AOO but works with LO) - click here.
Even after asking for the .odb and table information, you only provided info for one of the two tables and a form screen shot. This does me little good in looking at your specific problem. In order to proceed, I created my own tables & form and here I describe how you should have yours set.
First, make sure this setting is turned on. From the main .odb screen menu, select Edit->Database->Advanced Settings. On the Special Settings tab, make sure Replace named parameters with '?' is checked (sixth item from top):
Next I have two tables:
The two tables are related using the ID in the HOUSEHOLD table in the HOUSEHOLDLINK field of the FAMILYMEMBERS table.
Next a form is created:
The FAMILYMEMBERS table control is a sub form of the HOUSEHOLD table control form. Notice the ‘master’ & ‘slave’ link in the sub form properties.
Now with all in place, here is the resulting form:
When the record in the HOUSEHOLD table control is selected the associated records in the sub form are displayed. The last row of each table control has a yellow * in the far left column. This indicated where NEW records may be entered.
If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.
very, very thanks for your help
Today testing, I work well in openoffice 4.1.4 but not in libreoffice 5.4.4.2
Has not this been due?
Thanks again
This worked for me in LO v5.4.x using Linux. Are you saying yours didn’t work?
Yes, and with openoffice I can enter the control of tables without problems.
If there was any way to pass the compressed file, I would send it to see it better
Very thank you.
Just edit your question and post a copy of your .odb file. This will give me something to look at. Use the ‘paperclip’ on the toolbar (menu in your question when you edit it) for this.
