>>>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?
>
>While Dragans approach certainly has merit, your approach might be faster.
I suggested that if this faster approach doesn't show the cause, or contains just pure fox objects and properties (like 'insert ... values o.field1, o.field2') etc, which you can't quite run outside of fox.