I made a first mistake in the [ENTITIES] section of my asn.
I solved my problem by I forgot to restart the Userver after changing my asn, so I was still testing with my wrong asn...
Sorry.
Original Message:
Sent: 02-02-2024 08:14
From: Nicolas Colmart
Subject: Model name added to table name in the MSS 'select' sql statement
Hi Gilles
We are using a standard 'retrieve' on the entity
I'm not using the same asn in the 2 situations as one is for the Urouter and the second one is for the Client/Server version
But the settings for database and entities are the same in both asn files:
- in [PATHS] sections I'm connecting to the same database
- I'm using the same USYS$MSS_PARAMS options in the [DRIVER_SETTINGS] section
- I have no settings in [ENTITIES]. The $DEF path is linked to my $MSS path
Nicolas
------------------------------
Nicolas Colmart
Self Registered
Nice FR
Original Message:
Sent: 02-02-2024 06:12
From: Hortion Gilles
Subject: Model name added to table name in the MSS 'select' sql statement
Hi Nicolas,
What proc instruction are you using to read your table (sql,retrieve,select) ?
It's weird that it add the name of the model .. but i usually work with ORACLE maybe is different with MSS...
Are you sure you are using the same asn in both of your cases ?
Maybe your section [ENTITIES] is not the same...
Gilles.
------------------------------
Hortion Gilles
Dedalus Healthcare France
Artigues Pres Bordeaux FR
Original Message:
Sent: 02-02-2024 05:31
From: Nicolas Colmart
Subject: Model name added to table name in the MSS 'select' sql statement
Hi
We have created a REST API with a uniface component.
This API calls some services to extract data from the database.
When the service is called from the API (so running with userver), the 'select' is made on [table.model] table in the MSS database, so MSS returns that the object name is invalid
Example : select [pcli_cd] from [pclient.parametres] where 1=0
When the service is called from a standard client/server form, the 'select' is made on [table] table in the MSS database
Example : select [pcli_cd] from [pclient] where 1=0
My question is : how to avoid the model name to be added to the table name ? Is there an option somewhere
Thanks for your help
(Environment : Uniface 9.7.04)
------------------------------
Nicolas Colmart
Self Registered
Nice FR
------------------------------