database viewer

0
i want to delete or update a row in database using built-in database viewer. but no sql commands is working for me. only commands provided by viewer is working. unable to use query. I think that i am writing wrong syntax, please anybody know how to do something using attributes of entity in commands. Error: user lacks privilege or object not found: ID / Error Code: -5501 / State: 42501    
asked
3 answers
1

Hello Lalit,

To update attribute value in entity – UPDATE "Table name" SET "Ättribute name" = "Value”

To delete the entry- DELETE FROM "Table name" WHERE Ättribute name" LIKE '%%'

Hope it helps!!

Thanks

 

answered
1

Never use the database viewer to delete records. This will corrupt your data at some point. Create overview pages per entity for your admin. These can be automatically generated from the Domain model.

This will allow you to create, edit and delete Data using the runtime and keep you data valid.

 

 

 

 

 

 

 

 

answered
0

Hi Lalit,

 

You cannot access the attribute ID (as the unique record identifier). Not on any select, insert or update the ID through SQL or OQL. You have to find a way to work around the ID attribute.

 

Hope this helps,

Jan

answered