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/SelectFunction.java
SelectFunction.java | ||
---|---|---|
71 | 71 |
FUNCTION_SELECT, |
72 | 72 |
Range.is(6), |
73 | 73 |
"Returns a list of features of the table by applying the filter, order and limit indicated.\n"+ |
74 |
"The syntax is:\n\n"+ |
|
75 |
"SELECT * FROM table WHERE boolean_expression ORDER BY order_column LIMIT limit;\n\n"+ |
|
76 |
"Indicate a filter expression with WHERE, an order or LIMIT is optional.\n"+ |
|
77 |
"The SELECT statement must always end with a semicolon.", |
|
78 |
"SELECT * FROM {{table_name}} WHERE filter ;", |
|
74 |
"The syntax is:\n\n"+ |
|
75 |
"SELECT * FROM table WHERE boolean_expression ORDER BY order_column LIMIT limit;\n\n"+ |
|
76 |
"Indicate a filter expression with WHERE, an order or LIMIT is optional.\n"+ |
|
77 |
"You can use an asterisk or enter the column names you want to retrieve separated by commas.\n"+ |
|
78 |
"The SELECT statement must always end with a semicolon.", |
|
79 |
"SELECT * FROM table WHERE boolean_expression ORDER BY order_column LIMIT limit;", |
|
79 | 80 |
new String[]{ |
81 |
"column_names/asterisk - Names of the columns table to retrieve.", |
|
80 | 82 |
"table_name - Name of the table", |
81 | 83 |
"filter - boolean expression to apply as filter", |
82 | 84 |
"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.", |
Also available in: Unified diff