[Libreoffice-bugs] [Bug 117353] Error with Calc, when add data from FireBird RU

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117353

Al Ko  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED
 Resolution|WORKSFORME  |MOVED

--- Comment #5 from Al Ko  ---
This problem not related with LO Calc, perhaps with DBMS FireBird

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117353] Error with Calc, when add data from FireBird RU

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117353

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #4 from rob...@familiegrosskopf.de ---
(In reply to Al Ko from comment #3)
> Thank you for your attention to the request!
> 
> The problem was solved by changing the query, the field name was written in
> uppercase "ID", not "id", as before. 
> Expected the query to be case insensitive in field names.

Seems this doesn't happen with the internal Firebird database.

I will set this one to WORKSFORME, because this isn't a problem of copy and
paste to Calc.

Feel free to report a new bug for case insensitive field names. I don't know if
case-sensitive fieldnames are standard for Firebird 3.0. Don't think it is a
bug if LO will work with case sensitive fieldnames.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117353] Error with Calc, when add data from FireBird RU

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117353

--- Comment #3 from Al Ko  ---
Thank you for your attention to the request!

The problem was solved by changing the query, the field name was written in
uppercase "ID", not "id", as before. 
Expected the query to be case insensitive in field names.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117353] Error with Calc, when add data from FireBird RU

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117353

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 CC||rob...@familiegrosskopf.de

--- Comment #2 from rob...@familiegrosskopf.de ---
Have tested this one with
Version: 6.1.0.0.alpha1
Build-ID: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab
CPU-Threads: 4; BS: Linux 4.4; UI-Render: Standard; VCL: kde4; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group

No problems to import data from an internal Firebird-database to Calc. Used the
same table-structure ("id" INTEGER, "Name" VARCHAR). Used the same query.
Works.

The error says: The column "id" is unknown. Does the query run without problems
in Firebird?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117353] Error with Calc, when add data from FireBird RU

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117353

--- Comment #1 from Al Ko  ---
Created attachment 141792
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141792=edit
screenshot of error

screenshot of error

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs