Issue 37664

Summary: 'drop' command is not working
Product: Base Reporter: virtdb3 <virt_database>
Component: codeAssignee: marc.neumann
Status: CLOSED WONT_FIX QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.0.0   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
one-line description none

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