Jump to content

Hans J. Ellingsgaard

Members
  • Content Count

    44
  • Joined

  • Last visited

Community Reputation

9 Neutral

Technical Information

  • Delphi-Version
    Delphi 10.4 Sydney

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hans J. Ellingsgaard

    How to run Interbase developer in 10.4 and 11

    Yes, the developer edition can run via tcp. Have you checked wich port it's using? You can do that with netstat. You should also be able to telnet the portnumber..
  2. Hans J. Ellingsgaard

    How to run Interbase developer in 10.4 and 11

    If you connect via tcp/ip, it should not matter where your Interbase binaries are located, as long as the interbase service is running. You also need to check wich port it is running on. Normaly it's on port 3050.
  3. Hans J. Ellingsgaard

    Delphi 10.4, FireDac, StartTransaction causes ODBC error.

    Your problem might have something to do with nested transactions. If your db or your odbc driver don't support nested transactons, make shure there is no ongoing transaction on the same connectionm, before you call StartTransaction. Something like this: if FDConnection1.InTransaction then FDConnection1.Commit; FDConnection1.StartTransaction;
  4. Hans J. Ellingsgaard

    Delphi FireDAC .Post on Firebird table

    A primary key is a ground rule of relational daatabases.
  5. Hans J. Ellingsgaard

    Copy Encrypted InterBase Database to another machine

    Your problem could come from the gds32.dll client file. If it's in the windows\system32 folder it will be overwritten with each installation. Not all of them have been backward compatible.
  6. Hans J. Ellingsgaard

    FireDAC: Need help understanding "ConnectedStoredUsage"

    It works fine the opposite way - active at designtime and closed at runtime. I guess that most users use it that way. I allways make shure that all my queries are closed at programstart, and then open them via code.
  7. Hans J. Ellingsgaard

    Interbase IBX to Firedac TDatetime

    I have converted from IBX to FireDAC without any problems with the datetime fields. What database are you using?
  8. Hans J. Ellingsgaard

    Delphi IDE on AMD cpu?

    The Ryzen 5 processor is more than capable of running VM's on your PC. If it's not for gaming, go for a business PC, they have better hardware quality.
  9. Hans J. Ellingsgaard

    Target machine actively refused connection

    Have you checked if your interbase service is running? You can try to connect to it with tke IB Consol that comes with the Interbase installation.
  10. Could it be this problem you have run into? https://www.ideasawakened.com/post/rad-studio-10-4-2-is-now-available-with-possible-cure-for-the-blue-dot-problem
  11. Hans J. Ellingsgaard

    10.4 Could not compile dbgrids

    Check in your project folders to see if there is a dbgrid.pas or dbgrid.dcu file and remove it, if it's there.
  12. Hans J. Ellingsgaard

    Best Practices for FireDAC FetchMode/RecordCount Settings

    Is there anything that prevent you from indexing all the fields in the join and where clause? There is a good chance that it would give you a significiant boost on your query performance.
  13. Hans J. Ellingsgaard

    Best Practices for FireDAC FetchMode/RecordCount Settings

    If you make a select count query on an indexed field, it should only take a ms to execute. The resultset will only have one record. If your table only have 1500 records, the dataset.RecordCount should also respond quckly (not as quick as the record count thoug). There must be something else that goes wrong. What database are you using? Have you tried to run the queries directly in a db manager?
  14. Hans J. Ellingsgaard

    Best Practices for FireDAC FetchMode/RecordCount Settings

    A count(*) should always be done an an index field, or the point of using it is gone in the first place.
  15. Hans J. Ellingsgaard

    Best Practices for FireDAC FetchMode/RecordCount Settings

    To fetch all the records from a table to get the record count is in most cases a bad praxis. If it's a table with a lot of records, you will just put a lot unnessisary strain on the database server. A count(*) query, on the other hand, has a very limited impact on the server.
×