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