A bit vague description - if schema is defined in CA properties, .SelectCmd must adhere to that schema. If fields are mapped in schema or key/update lists, AFAIR you can tweak only the filter/where part.

>I have a cursor adapter that points a view in a postgreSQL database.
>I defined the cursor adapter to map all fields in the view
>When i try to recover data from the view with cursorfill i have no problems if i decide to receive all defined fields.
>If i decide to reduce the number of fields and modify the selectCmd parameter in beforeCursorFill() method i can't open the view...... I have this problem only with some views... not all
>The error i have is :"syntax error at end of input Error while executing the query Code: 1526"
>
>Thanks