How to set auto commit disabled?

[kichigai]

Do support auto commit disabled? If support, how to set. If not support, exist implement plan? I use SQLPro Studio.

[hankinsoft]

For Oracle? Not currently supported. No ETA but I'll take a look at adding an option for it in the future.

On Wed, Feb 8, 2017 at 9:37 PM kichigai [email protected] wrote:

Do support auto commit disabled? If support, how to set. If not support, exist implement plan?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/hankinsoft/SQLPro/issues/76, or mute the thread https://github.com/notifications/unsubscribe-auth/ADA50FiUDiu0WNkYIEQpgGPPQsVIgwphks5ram3vgaJpZM4L7mIu .

[kichigai]

I use for MS SQL Server 8. I can't find auto commit disabled option.

[thwinkle]

Please add this feature soon!

[242617]

Yes, I need this feature too.

[e-bashtan]

Please add this feature soon!

I use SQLPro Studio for postgres, and sometimes I need disable auto commit.

[nmaslakov]

It would be great if you add this feature! Thank you!

[Creekmind]

+1. I need this too. Thank you!

[octomine]

yes yes, exactly!!1 I need this feature too! add it please

[hankinsoft]

I'm not overly familiar with auto commit disabled which is why I've been silent on this issue. Setting autocommit disabled basically makes sure no actions occurs unless you specifically run a commit command? I'll need to investigate to ensure the drivers I'm using in SQLPro support it for each database engine. Specifically it looks like people are asking for this with MSSQL and Postgres? Any other database types requested?

[sariabod]

In the interim you can explicitly begin a transaction before you do your queries and nothing will be committed until you tell it to. I saved a favorite the looks like this and with a click you can get a transaction and start writing away.

START TRANSACTION;

-- COMMIT;

[icharge]

In the interim you can explicitly begin a transaction before you do your queries and nothing will be committed until you tell it to. I saved a favorite the looks like this and with a click you can get a transaction and start writing away.

START TRANSACTION;

-- COMMIT;

BEGIN TRANSACTION;

works on MSSQL.

2024 now. Stil have no this feature.