python driver not able to query a view ??

[former_member715007]

hello i´m using the python driver to query my hana db.

from hdbcli import dbapi

...

dbapi.connect(address='xxx', port=30015, user='SYSTEM', password='xxx#')

this query

Query="SELECT * FROM MYDB.OATC"

returns rows

but querying a view

Query="SELECT top 1000 * from MYDB.ItemStockByWarehouse WHERE WhsCode =1"

returns this error

hdbcli.dbapi.ProgrammingError: (259, 'invalid table name: Could not find table/view ITEMSTOCKBYWAREHOUSE in schema MYDB

is there any issues with views and python driver???

[former_member715007]

Hi antonio.a.ramos , This could be due to the view name containing lower case letters. (ItemStockByWarehouse) Putting quotes around the table name could fix this. Or it might be easiest, if you could create the view using only upper case.

[AndreasForster]

Hi antonio.a.ramos , This could be due to the view name containing lower case letters. (ItemStockByWarehouse) Putting quotes around the table name could fix this. Or it might be easiest, if you could create the view using only upper case.