>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
I've never used cursor adapters but if you manually run the modified command does it give you a syntax error?