Re: [libreoffice-users] Re: Base/Firebird Queries broken

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_mirowsky@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+unsubscribe@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+unsubscribe@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