Lajos Juhász

https://docwiki.embarcadero.com/RADStudio/Sydney/en/Conditional_compilation_(Delphi)

You can also test with regular VCL controls, the bug could be also in the DevExpress controls. With VCL placed on the form I don't have had placement problems.

40 minutes ago, Fr0sT.Brutal said:

In most cases try-finally is OK but for time-critical functions try block in Delphi is damn slow. That's where goto's remain the only option. Or, if possible, inlined sub-functions could help

It's fine until you get an exception, which will result in a memory leak.

Never had deadlock when using amblocking. On the other hand in D11 sometimes amCancelDialog will not work on query. You must change for the connection before and change back after the query is finished.

(I believe earlier if you have had no valid licence there was no possibility to renew the previous one. The only option was to buy a new licence.)

I do get codeinsight loading, however almost never freeze delphi.  Maybe try using process monitor to spy what code insight and / or the IDE is doing.

For third party and IDE settings you can use the migration tool (migrationtool.exe in the bin folder of the Delphi available for a couple of versions). As far as I know it will not download packages from getit, that could cause problems.

I like to stay on the safe side and reinstall everything.

What is the metric for efficiency? You would have to iterate the query and for every record check the value in a memory structure if it's there you have duplicate if not insert into it.

You can store the list in an array, list or a hash table.

3 hours ago, microtronx said:

and "ANSI"

it's a bad idea, only English text should be saved as ANSI, otherwise you should always save as UTF-8.

most probably in the part:

 .....
          /////     

Hi,

Usually I like to use TFDUpdateSQL to generate SQL's to update the database. Now I have a case where it would be easier to let FD generate the insert statement. However I fail to see how to customize the SQL.

For some reason for Informix:

function TFDPhysInfxMetadata.GetNameParts: TFDPhysNameParts;
begin
  Result := [npCatalog, npSchema, npBaseObject, npObject];
end;
 

In case of informix npCatalog that's makes no sense as it is the database name. npSchema is the user and that is a big no. I have a database with multiple users and rights.

Is there a way to customize to generate the table name without prefixes? (When ApplyUpdates generates the insert or update statement.)

The program was started with a different current folder option, or the WIN API SetCurrentDirectory was called somewhere from the application.

38 minutes ago, Remy Lebeau said:

You would need to call GetVariantManager() first to initialize the record before you can use it, eg:

You should check the implementation for that procedure:

{ ----------------------------------------------------- }
{       Variant manager support   (obsolete)            }
{ ----------------------------------------------------- }

procedure GetVariantManager(var VarMgr: TVariantManager);
begin
  FillChar(VarMgr, sizeof(VarMgr), 0);
end;
 

This will not fill the record properly.

Do not worry everything is going to work perfectly in the new 64 bit IDE.

It's obsolated do not use it (as it cannot be used). Checked even in XE5 was deprecated.

I wonder why it is not removed from the source.

You can inspect the source of the webpage. By clicking you execute the javascript:

I don't use fmx but https://github.com/project-jedi/jcl should work.

7 hours ago, Ian Branch said:

Alternatively, how should the above be now written?

From the source:

faVolumeID    = $00000008 platform deprecated;  // not used in Win32

Looks like it was removed from windows.

LocalExe is an environment variable. You can define it at Tools - Options - Environment Variables.

I am using the Infx driver (based on ODBC) and in that case the data is moved over the network using the db locale (ANSI or UTF-8) and at the FD or ODBC converted to UTF-16, when writing back unfortunately in case of ANSI database the db locale isn't used (instead the windows ANSI code page for non-unicode language and that can corrupt the data).

I expect to be similair in case of MSSQL.

1 minute ago, Uwe Raabe said:

Can it be that in the past you had a Professional edition with FireDAC extension and some remnants cause this?

No, it's Enterprise. 

That's correct.  I have both $(BDS)\source\data and  $(BDS)\source\data\firedac in the Browsing path and yet the IDE only data.db.pas can open correctly and not the FireDAC sources. In order to debug FD I have to rename the XE5 folder.

var

  lUser: TFDQuery;

begin

....

luser.open;

If I set a break point on open and do a step into it will open C:\Program Files (x86)\Embarcadero\Studio\22.0\source\data\data.db.pas (correct D11.2)

procedure TDataSet.Open;
begin
  Active := True;
end;
 

Step into the Active := true;

will open C:\Program Files (x86)\Embarcadero\RAD Studio\12.0\source\data\firedac\FireDAC.Comp.DataSet.pas (Delphi XE5).

I noticed only with FD sources, debugging VCL works as expected.

Now I tried no active XE5 and yet the IDE opens source from XE5 instead of Delphi 11.2

In the IDE the environment variable BDS is set correctly to c:\program files (x86)\embarcadero\studio\22.0. Even when the IDE is running from the command prompt I cannot inspect the value of this variable.

Createad a new variable bds28 and changed the browsing path to use that variable the result is the same the IDE opens the source from XE5.