BEGIN TRANSACTION PostgreSQL

Databases
1

Hi
SQLExecute(“BEGIN TRANSACTION”)
Trans
If Any Error call Rollback
SQLExecute(“END TRANSACTION”)

But is was working on Xojo 2015 v2.4 i am using Xojo 2015v 3.1 i note that is no working

any one have see this

2

i try XOJO 2015 r4.1 same problems

i have problems with my POS if any network problems or windows
i have account balance is bad now

if any other version of XOJO that work with it SQLExecute(“BEGIN TRANSACTION”)

3

“end transaction” should be “commit transaction” for postgresql

4

Or simply “Commit” or, easier, just call db.Commit.

5

yes i now
but is no getting on commit or end transaction and i look the DB and it post the vales after call Rollback

i am using PG 9.5v

6

Check the error messages after each call to the database to see if that provides a clue.

7

The problems i do no have the error the customer call me with this problems so i try to check Rollback is working.

What I understand is that everything that happens between the SQLExecute(“BEGIN TRANSACTION”) and SQLExecute(“END TRANSACTION”) any rollback or exit by other error shut no save any value.
only if you Commit or end TRANSACTION.

Yes/No

8

It’s “Commit [Transaction]”, not “End…”, but otherwise, yes. That’s why I think there is something else going on in your code.

9

like what ?
to look for

10

Again, any error messages after each call to the database.