Jump to content

Search the Community

Showing results for tags 'mysql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • uniGUI Public
    • Announcements
    • General
    • Feature Requests
    • Installation
    • Deployment
    • Other Platforms
  • Licensing
    • Licensing
    • Ordering uniGUI
  • Bug Reports
    • Active Reports
    • Closed Reports
    • Old Bug Reports
  • uniGUI Development
    • General Development
    • uniGUI Releases & Roadmaps
    • Utilities
  • Mobile Platform
    • uniGUI Mobile
    • Mobile Browsers
  • Users Area
    • Sample Projects
    • Components and Code Samples
    • Third Party Components
  • Non-English
    • Non-English
  • Miscellaneous
    • Hosting
    • Server Security
    • Jobs

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 4 results

  1. 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;
  2. 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
  3. Projeto que demonstra o poder do uniGUI e sua produtividade para facilitar a construção/migração de projetos novos/legados. Versão Project that demonstrates the power of uniGUI and its productivity to facilitate the construction / migration of new / legacy projects. Version
  • Create New...