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

I have replaced blanks with underscores in field names in tables.

I have removed alias named fields from queries.

It did not appear to make a difference.

I should note that tables Amps, Volts-High and  Volts-In have the same 
or more field names.

As each table name is prefixed to a field, I would not think this a 
possible error. Am I correct in this assumption?

Thanks

Paul

On 1/15/2019 11:27 AM, Alexander Thurgood wrote:
> Le 15/01/2019 à 16:14, Paul D. Mirowsky a écrit :
>
>
> Hi Paul,
>
> > SELECT "Equipment"."ID", "Equipment"."P_Model",
> > "Equipment"."P_Model_No", "Equipment"."Power Meter",
> Check that the space in the field "Power Meter" isn't causing an issue.
>
> There was a known bug about spaces being misinterpreted by the parser.
>
>
> > "Equipment"."Series", "Equipment"."Power Meter 2", "Equipment"."Power_No
> > 2", "Equipment"."Power Meter 3", "Equipment"."Power_No 3",
> Same here for "Power Meter 2" and "Power Meter 3"
>
>
>
> > "Ions-IM"."Ions", "Ions-IM"."Select", "Ions-IM"."Series",
> Also check that the field name "Select" in Ions-IM.Select isn't being
> misinterpeted.
>
>
> > "Volts-High"."Time", "Volts-High"."Reading" "Vo-Hi-Reading",
> What is "Vo-Hi-Reading" - is this supposed to be an ALIAS ? Maybe check
> whether that is correctly supported.
>
> > "Volts-High"."Type" "Vo-Hi-Type", "Volts-High"."Series",
> Same here with "Vo-Hi-Type"
>
>
> > "Volts-High"."Setting", "Amps"."Reading" "Am-Reading", "Amps"."Type"
> Same here with "Am-Reading"
>
>
> > "Am-Type", "Amps"."Series", "Amps"."Setting" FROM "Ions-IM",
> > "Equipment", "Volts-High", "Amps" WHERE "Ions-IM"."Series" =
> > "Equipment"."Series" AND "Volts-High"."Series" = "Ions-IM"."Series" AND
> > "Volts-High"."Date" = "Ions-IM"."Date" AND "Volts-High"."Time" =
> > "Ions-IM"."Time" AND "Amps"."Series" = "Volts-High"."Series" AND
> > "Amps"."Date" = "Volts-High"."Date" AND "Amps"."Time" =
> > "Volts-High"."Time" AND "Equipment"."Series" = 134 AND
> > "Ions-IM"."Select" = TRUE ORDER BY "Ions-IM"."Date" ASC,
> > "Ions-IM"."Time" ASC, "Ions-IM"."Ions" ASC
> Not sure about how many left join conditions you can currently have.
> That would probably need checking by removing them one-by-one until you
> get something that works.
>
>
> As Robert has mentioned, perhaps the migration didn't convert the data
> types correctly, so your comparisons in the join conditions are no
> longer working.
>
>
> Good luck !
>
>
> 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