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 <p_mirow...@bentaxna.com>
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 <
> p_mirow...@bentaxna.com>
> > 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: users+unsubscr...@global.libreoffice.org
> >> 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: users+unsubscr...@global.libreoffice.org
> 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: users+unsubscr...@global.libreoffice.org
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

Reply via email to