General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only