Details
-
Type:
New Feature
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: CM8.4.1.201210, CQB8.4.1.201210
-
Component/s: CUBRID Manager, CUBRID Query Browser
-
Labels:
Description
Sometimes the user may want to make insert or update sql with result records on the query editor.
I think, it convenient for the user if the user select some records and choose a menu as "make insert query" on the context menu, then it make a queries to clipboard.
Activity
Hide
- If it can't find primary key, it will be not shown something after WHERE clause and be shown reasons.
- If it can't support data types, it will be shown reasons on comments.
-- Not be supported columns: s set -- Can't create the where clause because of no primary key UPDATE t SET s='{0Performanceimplication, 1Typesoffragmentation0}' WHERE ;
Show
Isaiah Choe
added a comment - - edited
If it can't find primary key, it will be not shown something after WHERE clause and be shown reasons.
If it can't support data types, it will be shown reasons on comments.
-- Not be supported columns: s set
-- Can't create the where clause because of no primary key
UPDATE t SET s='{0Performanceimplication, 1Typesoffragmentation0}' WHERE ;
Hide
There are only supported data types now.
CHAR VARCHAR STRING CURRENCY DATE DATETIME DECIMAL DOUBLE FLOAT INT INTEGER MONETARY NUMERIC REAL SHORT SMALLINT TIME TIMESTAMP TINYINT
Show
Isaiah Choe
added a comment - - edited There are only supported data types now.
CHAR
VARCHAR
STRING
CURRENCY
DATE
DATETIME
DECIMAL
DOUBLE
FLOAT
INT
INTEGER
MONETARY
NUMERIC
REAL
SHORT
SMALLINT
TIME
TIMESTAMP
TINYINT
For testing:
1. execute a select query
2. select records what you want to export for the insert or the update query
3. select a menu what you want to do on the context menu
4. it will be created query(or queries) into your clipboard system