To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=67968
                 Issue #|67968
                 Summary|in query edit, deleteing table results in bad sql 
               Component|Database access
                 Version|1.0.3
                Platform|All
                     URL|
              OS/Version|Windows XP
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|none
             Assigned to|dbaneedsconfirm
             Reported by|jmills





------- Additional comments from [EMAIL PROTECTED] Sun Jul 30 23:32:08 -0700 
2006 -------
attached base file; edit query "DeleteTableError"; select and delete
QualifyingTimes; run query.  says:

syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

you now can't save, or view the sql to find out whats up.
this only happens if you can contact the (mysql) db.

if the db is offline, you can't edit the query in this way - you get an error
and the sql appears.  THEN you can edit the sql directly and save it!!!  used
this as workaround

---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to