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

Problem with pocket query on update statement on a table

Georg Jun 10, 2016

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

Felix Grund (Scandio) Jun 10, 2016

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

Georg Jun 11, 2016

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

Community resources

Support

Problem with pocket query on update statement on a table

1 answer

1 accepted

Suggest an answer

Happy Anniversary, Atlassian Community!

Kesha Thillainayagam

We want to hear how your non-technical teams are using Confluence!

Atlassian User Groups

Find my local user group

Groups near you