Normally I accede to the tables of a bbdd to take the necessary information. In this case are trying the access to a view but it gives me mistake.
In the previous view of the assistant when I select a table I see the columns with the corresponding records, but in the case of the view I only see the columns that compose the view as if it was not reading the records. The script appears well...
When I execute the script, a mistake appears to me: SQL Error: |o|p|´| sqlerrm(view_name) SQL Scripline: SQL State: 42000 VIEW: SQL SELECT * FROM view_name
I have asked if the views have special permissions and have said to me that if I can accede to the tables must be able to accede to the views.
Also I have tried with other views and to load a table before the view (in this case I recibed other error). The document is new and it hasnt macros or variables.
Googling SQL State: 42000 gives "Syntax error or access violation". Looks like there is some problems with your access rights. Have you tried accessing the view with a dbms?
Can you please post some load code so we can check it?
Something like
LOAD *; SQL SELECT * FROM VIEW_NAME;
should work.
Try with the assistant as well (Script Editor -> Connect -> OLE DB -> following instructions), as it provides you with a previous load and view of those fields contained in the view, so you acn load only relevant fields.
IMQQLIK wrote:I have asked if the views have special permissions and have said to me that if I can accede to the tables must be able to accede to the views.
IMQQLIK wrote: TABLE: SQL SELECT * FROM bbdd.view_name;
This should be preceded by a LOAD clause, in the same way I posted before. "Table:" is the name you will use to reference the table in QlikView, LOAD followed by the fields separated by comma, or LOAD *; (see the semicolon) to get all fields and then the SQL SELECT statement as you wrote.
.png "Miguel_Angel_Baeyens"){kind=avatar}
