Search the Community

Hello everyone, I am in the process of converting an old project from Bde to Firedac. Basically it's relatively easy, but now I'm at a point where I'm a bit desperate. With the Bde, TDatabase and TTable/TQuery components, I had set up a central connection in my main program and opened all the necessary TTable tables. Now DLLs of the program (dynamically loaded with LoadLibrary) could call a function in the central location (export method) and, for example, fetch a TTable object corresponding to a specific table. Regardless of whether the design is good or bad, it worked without any problems. We used "ShareMem" in the main application and all the DLLs. I then had access to the tables of the main program in the DLL and could, for example, call FindKey to jump to a specific position in the DB. With Firedac I left everything as it was, only instead of TDatabase I used TFDConnection and accordingly TFDTable etc. The code is definitely correct, I can connect and display the data in the Dbgrid. FindKey from the main program also works. Nevertheless, I always get false with FindKey from the DLL after I have fetched the TFDTable. Does anyone have any experience with this? Could it be that the connection does not arrive correctly in the DLL when I get the TFDTable object? On the other hand, something like fdtable.fieldbyname(...) works without problems from the DLL. So I don't understand why FindKey doesn't work. It is also the same TFDTable object that I get back from my main application, indexfieldnames is also correct, table and connection are open and everything. Nevertheless it does not work. Would be grateful for a hint, especially since it works with TTable. I hope I was able to explain the problem. FindKey was just an example, I´m not sure, if other methods called in the dll work properly either. The Idea behind this concept is that we have a central place and all DLLs have access to the main tables and can change the cursor position of the table or can be updated when another DLL changes the position of a table, because they all use the same tables from the main application. Is there a better concept for this in FireDac with DLLs? Or do I need to create methods in my main application for Table updates or methods like "FindKey" which can be called from the DLLs? That would be a huge refactoring and I want to avoid this! Thanks a lot!

Hi all, I recently migrated from D7 BDE (SqlServer) to D11 FireDac. All is working just fine, but the performance are getting worse. Have you got any advice about the better set up? Most of my query are read only select, aming to popolate DbGrid or to save data to other kind of structure. Thanks in advance

A long shot and completely related to my other post about d11-update-1-firedac-odbc-to-sage-returning-wrong-data. If I could make the original connection open then all would be good. Basically when I try and connect to the DB in my old app, I get a generic error. I have turned on ODBC logging, which didn't help. Knowing someone else has it working would mean it was worth trying to get to the bottom of that problem, rather than trying to track down a potential bug in D11. TIA JAC.

Hello, I recently installed the BDE components for Delphi 10.4.2 to test an abswer I was writing on StackOverflow. Then, a couple of days ago, a failed Windows bios update meant that I had to re-install Windows (and Delphi) from scratch. I couldn't immediately find the BDEInst.Exe I'd used to install BDE support (TTable. TQuery, etc) and googling around only led me to a couple of links to installing BDE support from the XE7 era and there is no BDE Installer for 10.4.2 in the "My Registered Products" section of the Idera website. Fortunately, I found the BDEInst.Exe I needed in the Downloads section of my profile under C:\Windows.Old. But, and I realise this might seem a slightly strange question, could somebody "remind" me please where I might have downloaded it from? TIA, Martyn

I am sorry to ask about the BDE in 2020, but we are trying to move a client from Windows7 to Windows10 and then eventually from the BDE to FireDAC I installed BDE v5.01 onto my machine using the installer ( 30868_bde_installer_for_rad_studio_delphi_c_builder_10.3_rio ) and apparently in order to give the client the ability to insall the BDE I must find BDE_ENT.msi on my machine ( in %programdata% ) and then give them that file to install. However, I cannot find BDE_ENT.msi anywhere on my system. I have even gone into %programdata% and manually searched for it and it is nowhere to be found. So, I guess my questions are: Do Embarcadero still sell or make available for download or to purchase the Enterprise version for clients ( not developers ) with a proper installer ? Can a proper installer be obtained from anywhere ? If the customer already has a licensed version of the BDE Enterprise (v4) are they allowed to get an updated installer ? Will this work on Window 10 (v4 or the latest version) ? What is the latest version of the client side of the BDE ? Sorry for all of these questions, but like I said earlier I am trying to move a client from Windows7 to Windows10 and then eventually from the BDE to FireDAC. So eventually they will be on FireDAC, but for now we need to get the BDE working.