Issue 37665 - "alter" command is not working
Summary: "alter" 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:26 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:28 UTC, virtdb3
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description virtdb3 2004-11-23 05:26:54 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 "alter table tablename set column name='value' 
where column name='value';(If the value is in characters it should be enclosed 
in double quotes)

Expected : Table should be altered
Comment 1 virtdb3 2004-11-23 05:28:20 UTC
Created attachment 19592 [details]
one-line description
Comment 2 marc.neumann 2004-11-23 09:39:03 UTC
alter command is not supported in query design
Comment 3 marc.neumann 2004-11-23 09:39:18 UTC
close