Description: Only attaching one file to the issue but there are a few of these that I've run across so far. I can't see why the form would throw the error it does after the assistant is finished. Also - the file includes a macro library and this form does have buttons that call into it, but the error happens before any macro code executes. You can run the test with macros disabled if you like. Steps to Reproduce: 1. Download and open the attached test file 2. Click on tables to start the migration assistant and answer yes when prmpted 3. Assistant runs to completion with no error messages 4. Open the single form in the file Actual Results: Error message: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -206 *Column unknown *LINK_FROM_ID *At line 1, column 51 caused by 'isc_dsql_prepare' Main form controls are connected and display data, Sub from table grid is empty. Expected Results: Forms works as expected. Reproducible: Always User Profile Reset: No Additional Info: Tested using Ubuntu 18.04 with build: Version: 6.1.0.0.beta1 Build ID: 8c76dfe1284e211954c30f219b3a38dcdd82f8a0 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: group User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/66.0.3359.181 Chrome/66.0.3359.181 Safari/537.36
Created attachment 142346 [details] test ODB Test file includes hsql db, 2 tables, 1 relation and 1 form and simple basic macros.
Created attachment 142349 [details] Hand migrated ODB with working form fist I tried to create a Main/Sub form in the migration assistant created firebird.sdbc file - that fails just like the original form. Then I opened the original hsldb.sdbc file and created new, empty firebird.sdbc ODB. Hand migrated the two tables via drag/drop and did the same for the single form - that is attached here. The form works here. NOTE - I did not hand move either the macros or the relationship, but I did go back and remove the relationship from the migration assistant generated file just in case that was the culprit, but nope still doesn't work.
On pc Debian x86-64 with master sources updated today, I could reproduce this. No specific error on console. I unzipped the odb file, no "LINK_FROM_ID" found with grep. I must recognize I don't use Base and don't even know how to make a subform.
*** This bug has been marked as a duplicate of bug 117589 ***
Ok I reopened this because it is not really a duplicate of the other issue, although it is the same bug but in different code. The migration assistant today creates initial firebird metadata with name parameter substitution turned off. Grabbing the little basic script from the closed issue for firebird generally: Option Explicit Sub ensureConnection() Dim DBDocUI as Object on error resume next 'XRay ThisComponent DBDocUI = ThisDatabaseDocument.currentController if not DBDocUI.isConnected then DBDocUI.connect end if on error goto 0 End Sub Sub Main ensureConnection() ThisDatabaseDocument.DataSource.Settings.ParameterNameSubstitution = true End Sub and running that against the migrated base files does indeed fix this problem, and the forms w/regard to main/sub form access work.
The problem started to happen after a29d97e6ddab8ec002ba9827bd5fc874117712e0, thus, not related to Tamás' work. Removing the Blocks section. Closing as RESOLVED DUPLICATED of bug 117053 *** This bug has been marked as a duplicate of bug 117053 ***