Lajos Juhász

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.

Could be the environment variable in the browsing path - it's in both version BDS. Will have to investigate on this one. I have to use both XE5 (production environment) and 11.2 some future developement.

(Now I have to figure out why sometimes TFDQuery.ResourceOptions.cmdExecMode is ignored)

Yes, the ide will jump to files from folder C:\Program Files (x86)\Embarcadero\RAD Studio\12.0\source\data.

So far I tought that the debug information is not correct with shipped FireDAC. However, today I noticed when in Delphi 11.2 I place a break point and the debugger stops the IDE will open a source from XE5 (fore FireDAC) didn't noticed for any other source. Then of course debug will be impossible. How can I fix this problem?

Skip the IDE and copy files in Windows, then open the project group from the new location?

2 minutes ago, PeterBelow said:

in Tbasicdm.DatamoduleCreate, is there really an underscore in the line after begin? That would be the source of the first error. The second may be a false positive, error insight is easily confused by conditional compilation...

Both are false positives as the original messages says (the project builds and runs ok):

 

Quote

Hello.

Delphi 11.2

I have 2 "errors" that show in this page (see errors.jpg).

Yet the project builds and runs ok. 

Delphi is known to have false positives in Error Insight.