PgDACVersion = '5.3.8';
Issues we've noticed when compiling for Centos7 under Rio 10.3 that don't seem to be a problem compiling the same code for Win64 on Rio 10.3
//Issue 1
Code: Select all
thisQuery.SQL.text := 'select x from table where field= :PARAMname';
thisQuery.ParamByName('paramNAME').asString := 'value'; //Under Linux - Param Name is now case sensitive
thisQuery.open;
Code: Select all
if thisQuery.locate('myCharVaryingNoSizeLimitfield','aValidValueInWRONGcase',[loCaseInsensitive]) then
//loCaseInsenstive ignored
Postgres 10
fConnection := TPgConnection.create(nil);
fConnection.Pooling := false;
fConnection.LoginPrompt := False;
fConnection.Options.ApplicationName := ExtractFileName(paramstr(0));
fConnection.Options.UseUnicode := true;
fConnection.Options.EnableComposites := true;
fConnection.Options.DefaultSortType := stCaseInsensitive;
thisQuery := TPgQuery.Create(nil);
thisQuery.Connection := fConnection;
thisQuery.readonly := true;
thisQuery.cachedUpdates := true;
thisQuery.FetchAll := true;
thisQuery.Options.LocalMasterDetail := true;
thisQuery.Options.StrictUpdate := false;