gkobler

Yes i did, but i can't get a specific answer fdcAmmann.Open; TRY fdqImportData.Open; WHILE NOT fdqImportData.Eof DO BEGIN ... some other code to store the data to a Firebird database ... fdcUpdateAmmann.CommandText.Clear; fdcUpdateAmmann.CommandText.Add(Format('UPDATE dbo.TDexAllocationTicketOut SET ReadDT = GETDATE() WHERE IDInt = %d', [fdqImportData.FieldByName('IdInt').AsInteger])); fdcUpdateAmmann.Execute; <<--- here i got the exception fdqImportData.Next; END; fdqImportData.Close; FINALLY fdcAmmann.Close; END; when i remark the Execute as a comment, there no exception are raises. So the connection must be active and working. The "TFDCommand.ResourceOptions.CmdExecMode" is set to "amBlocking", I think i have no Async commands. Otherwise D12 has made some changes. I tryed "MARS=Yes" and "MARS=No", still same exception.

Does anyone have experience with Firebird 4, D11.3, FireDAC and the new data type "TimeStamp with Time Zone"? I would like to show the time zone in my field, have no idea to show it. Thanks in Advanced

Watch the RSP there are a Workaround

Made an RSP at https://quality.embarcadero.com so Embarcadero can fix it

A new version is available V1.6.1.169. Support for FB5 RC1 and HDPI. Visit our Homepage and download the Trialversion: https://fbm.gksoft.ch

It was just for the beginning, after a while they opened it for all subscription members it think

Done. https://quality.embarcadero.com/browse/RSP-43311

Now i tryed the same test with D12, i can confirm that the Field are created as TSQLTimeStampOffsetField. But when i open the table now i got an exception (invalid argument could not convert the time) After that i add a GetText Methode procedure TForm1.FDTable1MONTIMESTAMPGetText(Sender: TField; var Text: string; DisplayText: Boolean); begin text:=Format('%s UTC(%d:00',[DateTimeToStr(Sender.AsDateTime),Sender.AsSQLTimeStampOffset.TimeZoneHour]); end; It will shows the follow result?? 756 Hours? When i look to the help file, it should be -12 .. +13 Hours! Also the property TimeZoneMinuts shows me 696 Did i found a bug?

In older Delphi versions, there was once the possibility to arrange your projects in a similar way as in the WP plugin

Didn't saw this changes on any note. But thanks, will try it next week.

The source code is unfortunately not public, but since D11.3 there are three demo projects that show how to create a WP plugin.

Under the Favorites Items you can ann some subitems with the + Button After creating subitems, you can click on them an add your prject on the right side as may you like. The added value of this plugin are, you can manage your projects where you working in a other way then delphi does. Also you can backup an restore this settings. Follow a small example how it could look likes.

https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Connect_to_Firebird_(FireDAC) Makes not diffenrent, if the icu files there or not (same directory how the exe file). I'm sure i use the new fbclient.dll from FB4. CAST is working, but for me it's just a workaround, and works with Querys not with Tables. In my opinion, when you add the fields, it will create a TSQLTimeStampField insted of a TSQLTimeStampOffsetField! The TSQLTimeStampOffsetField is what i need i think, because it has information about the timezone. But it's not possible to replace the field, you got an error But thanks for showing me a other point of view.

New Release Built 24 for Delphi 11.3 and 12. https://dwp.gksoft.ch

be carefull with the Auto Suffix, found a bug today in D11.3 but it could be also in D12. https://quality.embarcadero.com/browse/RSP-43284

i can confirm this bug at D11.3, not testet yet on D12. You can disabled the option in the registry, but it's sometime still active, have not found any reproduced way to find out why.

New Release Built 23 for Delphi 12 Athens https://dwp.gksoft.ch Hope the homepage shows correctly, i allways has problems when i update it. I just compiled the Plugin, i did some test with the beta, but i don't expect any problems. Otherwise when somebody has problems wir D12, please report to me her at this thread. Thanks

I think this is he asking for

Use debug .dcus should be true

I had the message from time to time, but it always went away after a restart. I have not dealt with it further.

It's not allowed to submit some files from Delphi, i think

New Built 23 released: https://dwp.gksoft.ch

Yes of course 🙂

I had the same problem, also I then disabled it via registry key. This also worked for a while, but at some point the checkbox was active again. Somehow I do not see the connection yet, when the checkbox becomes active again. And important: Delphi must be terminated first, before you make changes to the registry.

check the follow, may it could help https://blog.marcocantu.com/blog/2022-december-suggestions-help-delphi-compiler.html I have may 3th party components installed, incl. DevExpress. Have no problems with it, also in D11.3