Jump to content

Lars Fosdal

Administrators
  • Content Count

    3483
  • Joined

  • Last visited

  • Days Won

    114

Everything posted by Lars Fosdal

  1. Lars Fosdal

    Delphi job

    Quick, Good, Cheap - you can only pick two.
  2. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    CoInit/CoUnInit - Prior to starting DB components, and after the last disconnect I do this because I have zero control over what a DB driver does with regards to COM.
  3. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    I thought ckForwardOnly was implicit when setting Unidirectional to true. When you look at the Monitor log - are all field types what you expect them to be? Personally, I always use CoInitialize(nil); CoUnInitialize; for projects that use a DB driver. Also when there is only a single main thread.
  4. Then I am afraid that uninstall/reinstall is the next alternative. Unless @eivindbakkestuen has some other idea?
  5. Lars Fosdal

    memory paging or segmentation

    Can you rephrase that question? I don't understand it.
  6. Lars Fosdal

    Escaping UK pound sign in JSON

    No. PS C:\Users\foslar> '£'|ConvertTo-Json "£"
  7. Lars Fosdal

    Registration Renewal Failed

    Such issues needs to be raised directly with EMBT. Noone here can assist in resolving them.
  8. Is there a Nexus db connected component in one of the apps of yours, which is active at design-time, but which db cannot be reached from your PC?
  9. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    This is indeed weird. Have you called CoInitialize(nil); CoUnInitialize; at start/end of app/threads?
  10. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    Good point. I forgot about that since we don't use DB controls but feed regular grids from our query data.
  11. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    I don't see any such limitation mentioned?
  12. I assumed any unmatched on-events would have been silenced. If E is nil - logging will be incomplete in some cases, since I pass the exception object to Eurekalog to capture a callstack for the log. It probably would be quite rare, though.
  13. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    Not from the top of my head. I would definitively check the monitor to see if there is something enlightening in there?
  14. With TCP/UDP/Serial, JsonRPC, REST, Databases and conversions and partial data transfers possible - you tend to accumulate a number of these.
  15. When dealing with live data, there is no end to what can go wrong - so no - I do not have a small number of top level exception handlers.
  16. That is extremely significant. I have countless numbers of these and I am starting to wonder if they should be rewritten to try // ... except on E: Exception do begin end else raise; end; and then have a general handler for those further out. Or.... just log "An unidentified terrible event happened."
  17. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    FDQuery.FetchOptions - Does changing Unidirectional to True have any effect? FDQuery.FormatOptions have a TON of settings, including map rules - which may solve encoding issues if the ODBC doesn't provide all the info that FireDAC wants. I.e. you can explicity specify the type of value that the db field should be translated to. From the Delphi Tools menu: FireDAC Explorer can help with experimenting with Format/Fetch options. FireDAC Monitor can also give good insight into the low level goings on when your application is running. Edit: I also wrote this a few years back: .
  18. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    I was thinking along the lines of eliminating the way the 32-bit ODBC is used as the core problem for the Delphi app. The next thing I'd look at, would be encoding, language, locale issues.
  19. Lars Fosdal

    D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!

    @Jasonjac2 Do you get the same problems with the 64-bit ODBC and a 64-bit Delphi app?
  20. Regular TCP telegrams are low cost, event oriented, cross platform, cross tool. The only hassle is identifying the port of the server, which typically would be a config setting.
  21. Lars Fosdal

    memory paging or segmentation

    @milurt As timfrost wrote Your exception happens because you go from 0 to 70000 instead of 0 to 69999.
  22. Lars Fosdal

    Async/Await with updating visual controls

    I do 🙂 Both to deliver tasks to worker threads, and to collect the updates and results.
  23. Lars Fosdal

    memory paging or segmentation

    or ... GetMem(ballnumber, 7000); FillChar(ballnumber[0], 7000, 5);
  24. Lars Fosdal

    How do i control the Login Form shape of Datasnap Rest Service

    Datasnap is intended for serving applications with data, not for being a custom Web UI. Not sure if you can customize any html part of it?
  25. Lars Fosdal

    Delphi 11.3 is available now!

    Personally, I'd sacrifice build speed over code speed, and there are ways to reduce the impacts of slower build speeds, like continous background builds, etc.
×