Search the Community

Hi All, I have a big problem in FireDAC Transactions With UniGUI and MySQL The Problem is that the Connection does not commit the transaction until I close the program and re-open it or until i add another voucher. for example, If I have two users working on the same database, every user open the program on his browser. If (User 1) add new voucher let's say the new VoucherID will be 125, after seconds (User 2) wants also to add a new voucher, the fdquery can't find that the (User 1) added voucherID Number 125, so it will gives him that the new VoucherID also 125 not 126. This happened when I have many queries executed with one transaction. I did't face this problem when I work on Normal Desktop Application in delphi, only when I use UniGUI Trial Version:1.90.0 build 1564 and older The MySQL Database is on Outside Server with Mochahost and I am using Delphi 10.3 My Code is like the following: var VoucherID : Integer; Begin qryGetVoucherID.Close; qryGetVoucherID.Open; VoucherID := qryGetVoucherIDNewID.Value; // the query statement is: Select IfNull((Select Max(VoucherID) + 1 From vouchersheaders),1) as NewID; qryVouchersHeaders.Append; qryVouchersHeadersVoucherID.Value := VoucherID; // ....... ..... FDConnection.StartTransaction; try qryVouchersHeaders.Post; .... .... qrysaveCheques_payments.execute(chRecCount,0); qrysaveWallets_payments.execute(chRecCount,0); qrysaveAccountingEntries.execute(chRecCount,0); FDConnection.Commit; qryVouchersHeaders.Refresh; qryCheques_Payments.Refresh; qryWallets_Payments.Refresh; qryAccounting_Entries.Refresh; except FDConnection.rollback end; End;

Projeto RadCORE - UniGUI Help file in Portuguese and English More informations https://t.me/projetoradcore

Hi All, I am using unidbgrid and i connect it to datasource and connect the datasource to fdquery with MySQL Cloud Database, some times it works ok and sometimes it gives me this error message: operation not allowed on a unidirectional dataset. so does anybody know the reason? Osama Ghazal

Projeto que demonstra o poder do uniGUI e sua produtividade para facilitar a construção/migração de projetos novos/legados. Versão 1.5.0.200 Project that demonstrates the power of uniGUI and its productivity to facilitate the construction / migration of new / legacy projects. Version 1.5.0.200