Frickler

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". 

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?

35 minutes ago, Stano said:

MAX(TDATE)

...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

On 1/7/2022 at 10:29 AM, audi30tdi said:

I use Paradox tables in my old application, and therefor I use the Database Desktop. But as @Virgo said, it shows the error, and the nothing more happens after I click run this program without getting help............

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.

On 1/5/2022 at 2:09 PM, Serge_G said:

Good news to have now recursive ones, and can we expect in a near future, windows functions?

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.

On 12/30/2021 at 4:17 AM, Joseph MItzen said:

It doesn't, unbelievably.

With Update 2, Interbase 2020 has now CTEs.

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

On 11/16/2021 at 12:40 PM, Henry Olive said:

Thank you SO MUCH  Serge, Vandrovnik

SUBSTRING solves my problem
 

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.

On 11/18/2021 at 8:33 PM, Dmitry Arefiev said:

Delphi 11 Update 1 will support 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.

On 8/13/2021 at 4:41 AM, Joseph MItzen said:

...it was SLOW. Incredibly slow. Queries that ran instantaneously in dbs like FireBird took many seconds to run in Absolute. In fact I recently ran across one of my old programs compiled with Absolute Database and ran it on a modern CPU and... yes, it wasn't my imagination. Still unbelievably slow on a system that has to be at least six times faster than the one the code was originally written for. 

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). 

On 8/14/2021 at 3:59 PM, dummzeuch said:

(Just in case somebody wants to suggest them: Class helpers didn't exist in Delphi 7 either.)

But interposers did.

It's possible that Interbase supports only "simple case", that is 

case foo
  when 1 then 'one'
  when 2 then 'two'
  else 'many'
end

What if you remove the parentheses around the case statement?

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

23 hours ago, Markus Kinzler said:

https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-extengines

https://github.com/FirebirdSQL/firebird/tree/master/examples/udr

http://www.firebirdsql.org/file/community/ppts/fbcon11/Firebird3Plugins2011.pdf

Pascal example:

https://github.com/Arcantar/FirebirdSQL_Sample

On 7/1/2019 at 12:07 PM, Attila Kovacs said:

@PeterPanettone No, I'm not slandering anything. I'm trying to stay objective and I welcome any new components, I'm sure you did not read my previous posts in this thread. Also, I'm using only svg's in my apps since years. Here is a little demo with http://www.riversoftavg.com/svg.htm and there is at least one more SVG lib which is suitable for this not including svg magic.

 

I can see pros and cons in both libs but I won't go into the details.

 

 

here.zip

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