Jump to content


  • Content Count

  • Joined

  • Last visited

Everything posted by Frickler

  1. Frickler


    ...would require GROUP BY, and then problems arrive with "AA" and "BB" not being grouped.
  2. Frickler

    FB3 Get Connected Users List

    The User Table is named MON$ATTACHMENTS See https://firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref30/fblangref30-appx05-montables.html#fblangref-appx05-monattach
  3. Frickler

    Which version BDE

    FireDAC doesn't support Paradox at all. You have to port to another Database, e.g. Firebird. But beware, no more SetRange and Filter, but SQL only.
  4. Frickler

    error on Interbase 2020 server

    I don't think so. I think InterBase is designed to be very slim and fast. For example, for everything except the most essential internal functions you have to use UDFs. Furthermore, it looks to me that the main use case is still embedded SQL like in ye olden times of InterBase on UNIX.
  5. Frickler

    error on Interbase 2020 server

    With Update 2, Interbase 2020 has now CTEs.
  6. Frickler

    Classic problem: "xnet://Global \Local\FIREBIRD"

    Don't add "Port" and "Protocol" if using embedded.
  7. Frickler

    Firebird 4.0 UDF

    Interbase has virtually no internal functions. Not even in the newest versions. All has to be done in UDFs. The Firebird developers on the other hand had changed that from the beginning.
  8. Frickler

    Delphi/FireDAC and Firebird 4

    Full support including the new 128 Bit types, timestamp with timezone and the new batch API for INSERT/UPDATE? I ask because UniDAC/IBDAC only supports a subset at this time.
  9. Frickler

    Absolute Database question

    Using SQL, it's slow. But Absolute Database isn't made for SQL, but for good ol' ISAM: IndexName, SetRange, Locate, Filter, you name it. There (and in single user mode) it is really fast. And you not only don't need any DLLs to access it, you can even embed the database into the EXE (for read only databases such as catalogues).
  10. It's possible that Interbase supports only "simple case", that is case foo when 1 then 'one' when 2 then 'two' else 'many' end
  11. What if you remove the parentheses around the case statement?
  12. Frickler

    MiTeC DFM Editor 8.0.0

    Is it possible to do manipulations like "multiply all 'Left' properties by 2" using this DFM Editor?
  13. Frickler

    Firebird 3 and SP in Object Pascal

    Pascal example: https://github.com/Arcantar/FirebirdSQL_Sample
  14. Frickler

    SVG Magic released

    Could you please provide the source code of your little demo?