Thanks for posting your solution. I ran into the same problem and probably
wouldn't have figured it out without your post.
- Tom
On Monday, April 15, 2019 at 5:20:36 AM UTC-6, gliporace wrote:
>
> I think I found the problem:
> the query is sent with the table name double-quoted:
>
> select
I didn't create the table, I was trying to connect to a read-only view from
one of our oracle servers, I'm just a user:)
Thanks for the explanation though, now I changed the name of the table to
uppercase in the model definition
and it works without entity_quoting = False.
Gianfranco.
Il
When a table is created in Oracle, it is always created in uppercase
letters, if not created by using quotes.
create table test= TEST
create table "test" = test
it is very likely that the table when created, was created without quotes
and hence the table name is saved in uppercase letters.
Now
Damn Oracle! Can you find some documentation that says that quoting of
table names is not supported and we will change? Want to make sure there
not some other configuration quirk before removing a useful feature.
On Monday, 15 April 2019 04:20:36 UTC-7, gliporace wrote:
>
> I think I found the
I think I found the problem:
the query is sent with the table name double-quoted:
select "ana_paz"."COGNOME", "ana_paz"."NOME" from "ana_paz" where
"ana_paz"."COGNOME"='ROSSI' <--- doesn't not work ("table or view does
not exists")
select ana_paz."COGNOME", ana_paz."NOME" from "ana_paz"
This is the query:
query = (db1.ana_paz.COGNOME==form.vars.cognome.upper())
if form.vars.nome:
query = query & (db1.ana_paz.NOME==form.vars.nome.upper())
if form.vars.data_nascita:
query = query & (db1.ana_paz.DATAJ_NAS==form.vars.data_nascita)
try:
6 matches
Mail list logo
