Ask Your Question

Can I have a subform on a form with a Table Control?

asked 2019-08-29 03:58:09 +0200

wyomason gravatar image

image description When I attempt to do this, I get the following error: The data content could not be loaded. firebird_sbdc error: *Dynamic SQL Error *Sql error code =-206 *Column unknown *LINK_FROM _CATID *At line 1, column 60 caused by ‘isc_dsql_prepare’

CATID is the index field that links the two tables used by the form and the subform.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-29 04:34:22 +0200

Ratslinger gravatar image


There is an existing Bug after converting HSQLDB to Firebird. This deals with sub forms and the error you received. There is another error of this type dealing with a MySQL database. Both can be fixed by either running a macro or editing a file within the Base .odb.

I would recommend the macro and have created an extension to make it easier. See this post -> How to unzip ODB file and edit the content.xml file to fix Firebird bug?. The related bug # is also there.

As with any fix, PLEASE make a backup copy first. Have run this myself numerous time without a problem but there is always a first time something can go wrong.

You can remove the extension when done if desired or leave it installed if you have other files to convert. It only need be run once to fix the problem.

edit flag offensive delete link more


BTW - The answer to your title question is Yes. You can have a variety of forms, sub forms, sub sub forms, etc. on a Base form document.

Ratslinger gravatar imageRatslinger ( 2019-08-29 05:40:00 +0200 )edit

The post to which you linked in your answer was very helpful, and solved the problem I was having. Thank you very much!

wyomason gravatar imagewyomason ( 2019-08-30 02:33:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-29 03:58:09 +0200

Seen: 22 times

Last updated: Aug 29