Howdy Paul, No you don't need to go back - the parameter substitution is for problems with sub forms and now I think you are just dealing with SQL differences between HSQL and Firebird with regards to how it implements joins in select statements.
On Wed, Jan 16, 2019 at 2:36 PM Paul D. Mirowsky <[email protected]> wrote: > Hello Drew > > I assumed that you are answering the question on error 104. > > I changed the file as per your instructions to > > db:parameter-name-substitution="true" > > , but error 104 is still there. > > Do I have to go back to my original file a migrate again with this fix > or am I fixing > > SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION > Thanks > > Paul > > On 1/16/2019 11:42 AM, Drew Jensen wrote: > > Howdy, > > > > Yes, I have a suggestion - there is a property in the Base file which is > > incorrectly set during the Migration Assistant run and must be fixed. The > > error message looks like this is what is biting you. > > > > The fastest way to fix it is at follows: > > Close the base file and exit LibreOffice. > > Rename the base file from <filename>.odb to <filename>.zip > > Now open the file with your favorite zip tool. > > You fill find a file named content.xml in the root of the file. > > Open that with a text editor. > > Search for this string: db:parameter-name-substitution="false" > > Edit that so that it reads db:parameter-name-substitution="true" > > Save your changes. > > Close the zip file, it should ask if you want to update the file with the > > change and answer yes. > > Change file name back to <filename>.odb and you should be good to go. > > > > Best wishes, > > > > Drew > > > > On Wed, Jan 16, 2019 at 11:27 AM Paul D. Mirowsky < > [email protected]> > > wrote: > > > >> Found this at > >> > >> > https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1 > >> > >> |SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION > >> >= 2.1 Only problem is, when run as "Execute SQL Statement" menu item, > >> it errors as > >>> 1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 > >>> *Token unknown - line 1, column 50 *. caused by 'isc_dsql_prepare' > >> I'm sure it's buried somewhere. Any hints anyone? I am by no means an > >> SQL expert, Thank you for being patient. Paul | > >> > >> On 1/16/2019 2:27 AM, Alexander Thurgood wrote: > >>> Le 16/01/2019 à 00:19, Paul D. Mirowsky a écrit : > >>>> Invalid usage of boolean expression > >>> This bug perhaps ? > >>> > >>> > >> > http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel > >>> Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2 > ? > >>> > >>> > >>> Alex > >>> > >> -- > >> To unsubscribe e-mail to: [email protected] > >> Problems? > >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >> Posting guidelines + more: > https://wiki.documentfoundation.org/Netiquette > >> List archive: https://listarchives.libreoffice.org/global/users/ > >> Privacy Policy: https://www.documentfoundation.org/privacy > >> > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
