Jump to content

Frickler

Members
  • Content Count

    26
  • Joined

  • Last visited

Community Reputation

8 Neutral

Recent Profile Visitors

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

  1. Frickler

    Feedback Request - FastReports vs ReportBuilder?

    Until 2005 we used to use QuickReport Pro with QuickReport Designer, which was very buggy at that time. So we tried ReportBuilder Pro. It was very stable, had great documentation and lots of useful features. But it was so slow. Printing a report took more than ten times as long as with QR. Then we tried FastReport - and never looked back.
  2. Frickler

    Retrieve count values on different columns

    Hmm... 50 columns? So why not concatenate all of them and get the combined length, subtract this from 50 * 5 (length of "False") and you get the count of "true".
  3. Have you tried ADO ("dbGo") instead of FireDAC?
  4. Frickler

    BDE + 10.3 and error $210C

    If you don't need to access Paradox, only DBF, you can try TDbf. See If you need SQL queries, use FireDAC LocalSQL witf TDbf.
  5. Frickler

    Is FireDAC extensible?

    Hi all, is FireDAC extensible, so that I can add a custom database driver, e.g. for Absolute Database?
  6. Frickler

    FB-3 SQL ROWS

    ...would require GROUP BY, and then problems arrive with "AA" and "BB" not being grouped.
  7. 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
  8. 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.
  9. 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.
  10. Frickler

    error on Interbase 2020 server

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

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

    Don't add "Port" and "Protocol" if using embedded.
  12. 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.
  13. 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.
  14. 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).
×