Frickler
Members-
Content Count
26 -
Joined
-
Last visited
Community Reputation
8 NeutralRecent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
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.
-
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".
-
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Frickler replied to Jasonjac2's topic in Databases
Have you tried ADO ("dbGo") instead of FireDAC? -
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.
-
Hi all, is FireDAC extensible, so that I can add a custom database driver, e.g. for Absolute Database?
-
...would require GROUP BY, and then problems arrive with "AA" and "BB" not being grouped.
-
The User Table is named MON$ATTACHMENTS See https://firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref30/fblangref30-appx05-montables.html#fblangref-appx05-monattach
-
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.
-
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.
-
With Update 2, Interbase 2020 has now CTEs.
-
Don't add "Port" and "Protocol" if using embedded.
-
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.
-
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.
-
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).
-
TCustomInifile.ReadSubSections in older Delphi versions
Frickler replied to dummzeuch's topic in RTL and Delphi Object Pascal
But interposers did.