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

View differences:

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