Ask Your Question
0

updating fk of a record gives an error (libre base ver: 5.1.6.2)

asked 2019-09-01 09:58:55 +0200

rajko gravatar image

Hi, i recreated this example: https://ask.libreoffice.org/en/questi...

but Im getting an error saying "Error updating current record". The problem is when i try to change DepID on a record libre base also try's to change the id of referenced record in Dep table. Why is libre base doing that?

Manny thanks

image description image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-09-01 17:46:11 +0200

Ratslinger gravatar image

updated 2019-09-02 04:29:19 +0200

Hello,

original post now deleted after addition of Edit #2. Was totally incorrect.

Edit:

Based upon your comment have deleted above.

Have tested the sample in the link provided and have had problems. While I can add new records (as shown), and I can modify the name field, changing an existing department using this method (query) produces the error shown - this on Ubuntu 18.04 using LO v6.3.0.4.

As asked in comment please elaborate on what you are looking to accomplish and there may be a different method.

Edit #2:

OK, have found the problem with the linked post answer. It is in the Query. Using the Right Outer Join is the cause. But to correct the situation had to use a different method only through SQL View. Therefore you cannot use the graphical interface. Have attached a sample based upon you original post. This sample does NOT include the macro referred to in the linked post. You can add that if you wish a refreshed list after each modification. Up to You.

sample ---- FKproblem.odb

edit flag offensive delete link more

Comments

Dep stands for Department, just needed two tables to illustrate my problem

rajko gravatar imagerajko ( 2019-09-01 22:57:23 +0200 )edit

Dept may have been a bit more helpful.

Best if you post a sample as can't tell much from images.

Also, why such an old version of LO? What OS?

Edit: Please explain what it is you are attempting as what you show as wanting to accomplish does not require a query or macro as in the provided link.

Just a simple straight forward form.

Ratslinger gravatar imageRatslinger ( 2019-09-02 00:18:08 +0200 )edit

Another possibility is for @EasyTrieve to respond to this as that was who posted answer in the link. Maybe can shed some light.

Ratslinger gravatar imageRatslinger ( 2019-09-02 03:10:26 +0200 )edit

@rajko, I would love to be able to help further with this right now, but am unable to due to other time constraints in my life. Seems like everything is falling apart at the same time. But I think the example I laid out is pretty clear, and I would suggest that you first try to get that example to work and make sure you clearly understand each and every step of it. Good luck.

EasyTrieve gravatar imageEasyTrieve ( 2019-09-02 03:29:05 +0200 )edit

@EasyTrieve,

Sorry to hear all is not well with you. Best wishes and will offer prayer for you that things get better.

Thanks for responding but just found the problem. You can check back in some future point as the resolution.

Ratslinger gravatar imageRatslinger ( 2019-09-02 04:12:58 +0200 )edit

@Ratslinger separate query does the job, thank you!

rajko gravatar imagerajko ( 2019-09-03 22:13:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-01 09:58:55 +0200

Seen: 39 times

Last updated: Sep 02