Revision 44925 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.impl/src/main/java/org/gvsig/expressionevaluator/impl/function/dataaccess/InsertIntoTableFunction.java
InsertIntoTableFunction.java | ||
---|---|---|
72 | 72 |
super( DALFunctions.GROUP_DATA_ACCESS, |
73 | 73 |
DataManager.FUNCTION_INSERT_INTO_TABLE, |
74 | 74 |
Range.is(7), |
75 |
"", |
|
76 |
DataManager.FUNCTION_INSERT_INTO_TABLE, |
|
77 |
null, |
|
75 |
"Inserts in the indicated table the records obtained from the specified SELECT statement.\n" + |
|
76 |
"Return the number of inserted records.\n" + |
|
77 |
"This statement must always end with a semicolon.\n" + |
|
78 |
"See the SELECT statement for more information on this.", |
|
79 |
"INSERT INTO {{table_name}} SELECT * FROM table WHERE boolean_expression ORDER BY order_column LIMIT limit;", |
|
80 |
new String[]{ |
|
81 |
"table_name - Name of the table in which to insert the records.", |
|
82 |
"column_names/asterisk - Names of the columns table to retrieve.", |
|
83 |
"table_name - Name of the table", |
|
84 |
"filter - boolean expression to apply as filter", |
|
85 |
"order_column - the order used to retrieve the features. It is a list of column names separated by a comma. The column name can optionally be followed by ASC or DESC to indicate whether the order should be ascending or descending.", |
|
86 |
"limit - Maximum number of features to return" |
|
87 |
}, |
|
78 | 88 |
"Number", |
79 | 89 |
false |
80 | 90 |
); |
Also available in: Unified diff