To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105272
                 Issue #|105272
                 Summary|Generated SQL Query is false
               Component|Database access
                 Version|OOo 3.1.1
                Platform|PC
                     URL|
              OS/Version|Windows Vista
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P1
            Subcomponent|none
             Assigned to|dbaneedsconfirm
             Reported by|gseguinot





------- Additional comments from gsegui...@openoffice.org Tue Sep 22 13:47:51 
+0000 2009 -------
When trying to filter data , for exemple searching number like 11, the system
back and error 

Statut SQL: 42P01

ERREUR: entrée manquante de la clause FROM pour la table « public.T_ADHERENTS »
  Position : 46

because the generated  SQL Query is erroneous.
Like this for exemple :
SELECT * FROM "public"."T_ADHERENTS" WHERE ( "public.T_ADHERENTS"."ref_commune"
= 1 ) ORDER BY "public"."T_ADHERENTS"."id_adherent"
You can see missing " after public and before T_ADHERENTS.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

Reply via email to