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