gkobler

Native driver is obsolete i think

I looked at the task and tried some of the things described there, but none of it helped.

I only had the FDQuery open and FDCommand was then executed in the While Loop. Nothing else, as shown in the example, I only deleted the Firebird statemens, but this is a different FireDAC connection. What kind of driver is it that can't even manage an open query with an UPDATE statement at the same time?

Possible, but in the doc no more info what i should set.

I tried Yes and No, No diffenrence same exception I had V17 first, then i made some changes with D12 and i got the truble. After that i updated to V19.3.2

Meanwhile i have a workaround for my problem. I changed my code to the follow fdcAmmann.Open; TRY fdqImportData.Open; fdmtImportAmmann.Data:= fdqImportData.Data; fdqImportData.Close; fdmtImportAmmann.Open; fdmtImportAmmann.First; WHILE NOT fdmtImportAmmann.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', [fdmtImportAmmann.FieldByName('IdInt').AsInteger])); fdcUpdateAmmann.Execute; fdmtImportAmmann.Next; END; fdmtImportAmmann.Close; FINALLY fdcAmmann.Close; END; the main changes are, first i open the FDQuery and copy the data to a FDMemTable, after that i close the FDQuery and my While loop are working with the TDMemTable dataset to with the query. So i got no exception and the UPDATE Statements is working well. Strange...

Have added the TFDMoniFlatFileClientLink component, and als added the parameter to my MSSQL connection 'MonitorBy=FlatFile' But when i open my connection, i got now the follow exception You can try to run the program with F9, but it hangs. I think FBMonitoring are buggy

Same exception 😞

Unfortunately, I do not have access to the server, which is managed by another company. I can ask if they see anything and if they can turn off MARS on the server side. I'm not sure if it could have something to do with D12. Because it used to work. But with D11.3 and older ODBC drivers. And there were also Windows updates on the PC and I don't know if there were changes on the server.

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.