Uniface User Forum

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)

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.

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)

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

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.

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)