Issue 37664 - 'drop' command is not working
Summary: 'drop' command is not working
Status: CLOSED WONT_FIX
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-11-23 05:18 UTC by virtdb3
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
one-line description (201.03 KB, image/bmp)
2004-11-23 05:21 UTC, virtdb3 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description virtdb3 2004-11-23 05:18:30 UTC 
1.Click the Programs tab in Start Option.
2.Select spread sheet in OpenOffice.org 1.1.3.
3.Click on Data Sources in view menu.
4.Expand the Data Source tree.
5.Right click on Queries and select New Query (SQL view)
6.Enter the SQL statement as "drop table <table name>;"

Expected : Table should be dropped
Comment 1 virtdb3 2004-11-23 05:21:02 UTC 
Created attachment 19591 [details]
one-line description
Comment 2 marc.neumann 2004-11-23 09:38:02 UTC 
drop command is not supported in query design
Comment 3 marc.neumann 2004-11-23 09:38:19 UTC 
close
Comment 4 Frank Schönheit 2004-11-25 09:52:18 UTC 
virtdb2, thanks for reporting that many issues with the query design - let me be
a little bit more gossipy about them than msc was :)

There are three things to note:
- the SQL view's main purpose currently is to execute SELECT statements. For
executing
  other statements, such as ALTER, DROP, etc., there's an "Execute SQL" dialog which
  you also reach via the context menu.
- If you use dBase as backend (I am not sure - your issue descrptions are
*really* good,
  but were missing this small fact :), then ALTER, DROP, etc. are also not
supported -
  OOo's dBase implementation simply does not support those DDL statements.
- Some statements (such as the "DESC" you mentioned in another issue) are not
  standard SQL, thus not supported by OOo DBA.

For the first two items, you could simply submit RFEs (Requests For
Enhancements). I am not sure if there already are some, if not, I'd encourage
you to do so.

Thanks a lot for your engagement!
Frank