[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


See below...

On 1/15/2019 10:37 AM, Robert Großkopf wrote:
Hi Paul,

Have a look at

"Ions-IM"."Select" = TRUE
Did the migrationtool set the field "Select" to a BOOLEAN-field?
Yes
"Equipment"."Series" = 134
Did the migrationtool import the field as a INTEGER field?
Not quite. Series is set to Number [Numeric]

There is no function in the query, only 4 tables connected ...
The only possibility to find the reason why Firebird couldn't execute
the query at this moment is to delete some parts of the query and try if
it will work without this parts.

By the way: There are only tables connected in theis query, not a view
connected with tables?
Not sure what you mean. These queries are developed to be linked to a Writer document as test data documentation. It is used to check the quantity of readings per unit at two each. Incorrect quantities of records prove data missing or inaccurate on import to Base.

Regards

Robert

Thanks

Paul


--
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

Follow-Ups:
Re: [libreoffice-users] Re: Base/Firebird Queries brokenRobert Großkopf <robert@familiegrosskopf.de>
References:
[libreoffice-users] Base/Firebird Queries broken"Paul D. Mirowsky" <p_mirowsky@bentaxna.com>
[libreoffice-users] Re: Base/Firebird Queries brokenAlexander Thurgood <alex.thurgood@gmail.com>
Re: [libreoffice-users] Re: Base/Firebird Queries broken"Paul D. Mirowsky" <p_mirowsky@bentaxna.com>
Re: [libreoffice-users] Re: Base/Firebird Queries brokenRobert Großkopf <robert@familiegrosskopf.de>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.