Noor

Hello everyone, I'm seeking insights on database development practices in Delphi with Firebird. I have two specific questions: When it comes to database development in Delphi, what is the recommended approach: utilizing data-aware components like drag-and-drop fields and linking with TFDQuery for CRUD operations, or segregating CRUD operations into separate units for forms? I'm particularly interested in understanding the balance between ease of use, efficiency and code usability. Any insights or examples you can provide would be greatly appreciated. Often, we encounter situations where we need to fix a bug or implement changes in just one form out of many (over 100 forms) within our system. Currently, we update the complete executable, which includes all VCL forms in one project. What would be the best approach to handle such incremental updates efficiently without impacting all clients? I'm eager to learn about effective strategies in this scenario. Thank you for your valuable input. Warm regards, Noor

Thank you, @Die Holländer, for the explanation and example provided. I'll attempt to write an example code using my years of experience with C# Entity Framework, primarily in the MVC context, and share a draft code for review. And, @PeterBelow, thanks for highlighting the pros and cons of project partitioning. We've decided to maintain one standalone executable to mitigate potential issues. While RAD is suitable for simple applications, for larger, complex projects requiring long-term maintenance, maximizing reusable code is imperative. Thanks, Noor