weirdo12

From what I gather, you were assuming CopyDataSet would automatically create a new table in an SQLite database. Is that correct?

Do you have a SELECT query in the Command property of the TFDTable component?

What you might be wondering is how FireDAC interprets a column that is defined to have the data type IMAGE when that data is read from the database. IMAGE is not a SQLite data type. Have a look at this page: https://www.sqlite.org/flextypegood.html

Do you qualify to connect to the database? ADDITIONAL LICENSE TERMS APPLICABLE TO RAD STUDIO, DELPHI AND C++BUILDER PROFESSIONAL, PROFESSIONAL WITH MOBILE, COMMUNITY EDITION, AND PROFESSIONAL ACADEMIC EDITIONS In the event Licensee has obtained a RAD Studio, Delphi or C++Builder Professional, Professional with Mobile or Professional Academic product license then the following terms apply. Subject to the terms and conditions of this Agreement, Licensor grants to Licensee as the licensed user of the Product the limited right to use those portions of the Product identified as "dbExpress" and "FireDAC", in executable form only, to access a local database installed on the same machine as the Work. Licensee may not use that portion of the Product identified as "dbExpress" or "FireDAC" in association with a database located on a different machine other than the machine on which the Works are installed.

Thanks for following up on the issue you were having.

What are you using as the server name?

My previous post was way off base. I'm still interested why you've had so much trouble getting TFDScript to work as you expected. I use it it with SQL Anywhere, SQLite, SQL Server, PostgreSQL and MySQL.

Are you setting the TFDScript.ScriptOptions.CommandSeparator property? Are all SQL statements terminated? sql_script->SQL->Add("ALTER TABLE \"dba\".truck RENAME dsptch15_truck;"); What does the code you a using look like?

Lars, to answer your question - no.

Did you consider just using SQLite?

If you can, purchase this: http://www.jensendatasystems.com/firedacbook/

I see this is an old question 😉 Anyway, I should have asked: Is there a particular reason you are using Firebird?

Why are you using Firebird?

Refresh meaning you call TFDQuery.Refresh?

Take a look at this line in the link Lars posted: CREATE INDEX / DROP INDEX. Instead of the SQL indexes, use the dataset indexes. Seems to me that means if the TFDMemTable has indexes they will be used.

Gross margin as a percentage: Gross Margin % = (Revenue – Cost of Goods Sold) / Revenue * 100 (Sell - Cost) / Sell * 100

You should take some time and read this topic: Configuring Drivers (FireDAC) - RAD Studio (embarcadero.com)

Create a new project and go through the pain of adding your source files to it. Not ideal, but you'll be happy for taking the time to do it.

Code completion works great in 10.4.2 - with Clang compiler projects.

I have no comment on the debugger parts of the question.

It's VERY fast - when using a Clang compiler.

Is this error produced from a new VCL application project? What version are you using?

I actually moved some software from the Classic compiler over to the 32-bit Clang compiler using 10.4.2! The project uses DevExpress, JEDI, AsyncPro, OnGuard, and Indy components.

Did you search your code for #pragma link "Data"?

FYI, this issue remains unresolved in 10.4.2. I added some more details to the report today.