Ask Your Question
0

Base subform creation problem. Parameter Input box, then error.

asked 2016-04-01 05:52:01 +0200

multiplexed gravatar image

Newbie alert here. If this post is wrong or if I need to provide more info, please let me know.

I’m following some tutorials on how to learn LibreOffice Base. I’m using the following …

  • LibreOffice v5.1 Base

  • MySQL ODBC connector (latest)

  • MariaDB v10.0.20

  • Windows 10 Pro x64 (Running LibreOffice)

  • Windows Server 2012 R2 Standard (hosting MaraDB)

I’m having problems creating a subform.

I’m using the create a form wizard. I have added both my tables and joined the primary key fields (employee-ID). When I open and run the form, I get a dialog box asking for “Parameter Input” (see screenshot). I don’t know what to input, so I click OK. Then I get an error …

The data content could not be loaded.
SQL Status: 42S22
Error code: 1054

[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.5-10.0.20-MariaDB]Unknown column 'ID' in 'where clause'

After clearing the error, the main form is populated with data. However, the bottom subform, has no data.

My question is, How do I get this subform to work, or how do I get rid of the “parameter input” dialog?

Here are some screenshots.

Parameter Input - dialog box to get rid of.

http://s16.postimg.org/x2oth5at1/Para...

Main Form Window

http://s18.postimg.org/4h828ys4p/Main...

Links

http://s23.postimg.org/qtnl9i617/Link...

Form Properties

http://s10.postimg.org/ivj7inr3t/Form...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-04-01 13:57:51 +0200

peterwt gravatar image

Is - allowed in field name? May be being interpreted as minus. The error message shows only "ID" as column name whereas your names are proceeded by other text including -.

edit flag offensive delete link more

Comments

Thank you very much! I was stumped on this one. I created a backup database, then renamed the Employee-ID columns to Employee_ID. I saved and re-created my subform. Everything is working great now. Thank you very much for your advice!!!

multiplexed gravatar imagemultiplexed ( 2016-04-02 07:58:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-04-01 05:52:01 +0200

Seen: 272 times

Last updated: Apr 01 '16