[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 Jochen changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution||NOTABUG -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 --- Comment #13 from Stefan Lindel 2012-07-27 06:44:37 PDT --- I found a other solution so you can close this thread -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 --- Comment #12 from Jochen 2012-07-26 19:28:22 PDT --- Hi Stefan, Please answer the questions. Otherwise this bugreport will be closed. Alternatively ask your question on a mailing list or in a forum -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 --- Comment #11 from Alex Thurgood 2012-02-26 23:45:10 PST --- (In reply to comment #10) > (In reply to comment #9) > > > > > > In base kann man keinen Befehl schreiben, der einen pro Zeile die > > Zeilennummer ausgibt, dieses ist für Listen sehr hilfreich > > Translation : > In Base it is not possible to write a (SQL) statement that gives a line number > per returned tuple, which is very useful for lists. > > So Stefan, if I understand what you want : > > 1 string1 > 2 string2 > 3 string 3 > 4 string 4 > etc, etc ?? > I would add that I don't understand why a simple autoincrement primary key field wouldn't solve the problem. All you would need then is a SELECT ALL. Sorry, but your problem is too vague and I don't see anyway to reproduce the buggy behaviour you claim exists without trying to guess what it is exactly you have started with, and what you are trying to achieve. Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 --- Comment #10 from Alex Thurgood 2012-02-26 23:40:07 PST --- (In reply to comment #9) > > > In base kann man keinen Befehl schreiben, der einen pro Zeile die > Zeilennummer ausgibt, dieses ist für Listen sehr hilfreich Translation : In Base it is not possible to write a (SQL) statement that gives a line number per returned tuple, which is very useful for lists. So Stefan, if I understand what you want : 1 string1 2 string2 3 string 3 4 string 4 etc, etc ?? But that still doesn't explain your SQL statement - which database have you been using where a statement like the one you have given works. At least, that would tell us which dialect of SQL you are using ? Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 --- Comment #9 from Stefan Lindel 2012-02-26 23:12:55 PST --- Am 27.02.2012 07:44, schrieb bugzilla-dae...@freedesktop.org: > https://bugs.freedesktop.org/show_bug.cgi?id=38340 > > --- Comment #8 from Alex Thurgood 2012-02-26 22:44:29 > PST --- > (In reply to comment #0) >> I want to use a query to add rowno in a selection: >> >> select (Select Sum(1) from orte O where O.ID> >> but i get an Error from the sql-Statement > > Hallo Stefan, > A bisserl mehr Infos könnten wir gut gebrauchen... > > > Alex > In base kann man keinen Befehl schreiben, der einen pro Zeile die Zeilennummer ausgibt, dieses ist für Listen sehr hilfreich -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 --- Comment #8 from Alex Thurgood 2012-02-26 22:44:29 PST --- (In reply to comment #0) > I want to use a query to add rowno in a selection: > > select (Select Sum(1) from orte O where O.ID > but i get an Error from the sql-Statement Hallo Stefan, A bisserl mehr Infos könnten wir gut gebrauchen... Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 Alex Thurgood changed: What|Removed |Added CC||ipla...@yahoo.co.uk --- Comment #7 from Alex Thurgood 2012-02-26 22:41:01 PST --- Hi Stefan, Without the table structure being used, the type of db, and some sample data, it is impossible to tell whether the problem is a parser one linked to the use of ALIASes, misinterpretation of 0 (zero) as INT/VARCHAR, or some failure to support the specific SQL instruction (e.g. sub-selects). Without further info, I will close this bug as invalid. Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 Julien Nabet changed: What|Removed |Added Status|NEW |NEEDINFO CC||serval2...@yahoo.fr --- Comment #6 from Julien Nabet 2012-02-25 06:32:11 PST --- Stephan: - did you try to reproduce this problem on a brand new document with 3.5.0 ? (with, if possible, brand new LO profile) - could you attach the file and give the details suggested by Alexander ? It may help a lot to understand the cause of the problem since we could try on Linux or Mac and see if there are error/warn messages. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 Stefan Lindel changed: What|Removed |Added Version|LibO 3.4.0 RC1 |LibO 3.5.0 Beta2 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 Stefan Lindel changed: What|Removed |Added Platform|Other |x86-64 (AMD64) Status|NEEDINFO|NEW --- Comment #5 from Stefan Lindel 2011-12-26 01:25:59 PST --- I testet under 3.5 beta2 and the error is the same -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 Björn Michaelsen changed: What|Removed |Added Keywords|NEEDINFO| --- Comment #4 from Björn Michaelsen 2011-12-23 16:59:50 PST --- needinfo keyword redundant by needinfo status. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 38340] RowNo in select BASE
https://bugs.freedesktop.org/show_bug.cgi?id=38340 Björn Michaelsen changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #3 from Björn Michaelsen 2011-12-23 12:27:41 PST --- [This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs