Community
Products
Confluence
Questions
Problem with pocket query on update statement on a table

Problem with pocket query on update statement on a table

I have the following statement

update  DBMANAGER.PROJECT set stellvertreter = :neuer where stellvertreter =:alter and nametechnisch = :project

when I press the "Change" button, the statement will probably run and change the values but with the error message

Bild1.png

Georg

1 answer

1 accepted

1 vote

Hi Georg!

Thanks for your interest in PocketQuery. I have to tell you: you're running a manipulating statement with PocketQuery. This is not supported. PocketQuery was designed as a read-only tool and only select statements will really work. Sorry to disappoint you.

Regards, Felix

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Is ok,I have something already thought.
But still nice plugin

Georg

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Suggest an answer

Confluence

Products

Interests

Groups

Community resources

Support

Problem with pocket query on update statement on a table

1 answer

1 accepted

Suggest an answer

How to earn badges on the Atlassian Community

Jessica Lynn

We want to see the templates you've created in Confluence!

Atlassian User Groups

Find my local user group

Groups near you