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
*Dynamic SQL Error
*SQL error code = -206
*At line 1, column 51
Main form controls are connected and display data, Sub from table grid is empty.
Forms works as expected.
User Profile Reset: No
Tested using Ubuntu 18.04 with build:
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 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:
Dim DBDocUI as Object
on error resume next
DBDocUI = ThisDatabaseDocument.currentController
if not DBDocUI.isConnected then
on error goto 0
ThisDatabaseDocument.DataSource.Settings.ParameterNameSubstitution = true
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 ***