General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Creating a minimal Cursoradapter in Code with table and alias set, then fool around with connection (different ODBC drivers or perhaps even OleDB) and SelectCmd gives better turnaround than for each attempt setting properties 100%.
Going from simple field to get a workable cursor, then add chunks of fields, joins or other SQL is often fastest way to find offending part.
CursorAdapter is adept at adapting itself...
Previous
Next
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