Problem with a DQL insert query

Hi,

First of all I don´t know whether I've started that discussion in the proper place,so I'm sorry if I haven´t.... I have a problem with a dql statement, my aim is to insert into a table (la_tp_nif) a row with only 3 values in the columns: object_name, la_atr_ubicacion and la_atr_pre_ubicacion. The query I'm using is this one:

insert into la_tp_nif(object_name,la_atr_ubicacion,la_atr_pre_ubicacion) values('myname','newplace','oldplace')

But when I execute, an error occurs: Error occured during query execution :[DM_QUERY_E_TABLE_NO_ACCESS]error: "The table, dmadmin.la_tp_nif, is not registered or you do not have access to it."

I have full access to the table for select queries, why is this happening?

Thanks!

Find more posts tagged with

Comments

Elchin_Mahmudov

Hi,

:[DM_QUERY_E_TABLE_NO_ACCESS]error: "The table, dmadmin.la_tp_nif, is not registered or you do not have access to it.

you have to register a database table

and query should be like that

insert into dm_dbo.la_tp_nif(object_name,la_atr_ubicacion,la_atr_pre_ubicacion) values('myname','newplace','oldplace')

Regards,

Elchin

dm_user

Hi,

Check the owner_table_permit, group_table_permit and world_table_permit from the dm_registered type.

If you are an owner, then 15 should be the value for owner_table_permit in order to get full access. Else for group, group_table_permit should have 15.

And if you dont get any object from dm_registered then as Echin said, register the table first like below:

For example

(object_namechar(5), ......... );

update dm_registered object

set owner_table_permit = 15,

set group_table_permit = 15,

set world_table_permit = 1

where object_name = 'la_tp_nif'

Try this, if it helpd you.

- Arindam