Olli73

Makes it no difference if you use platform or fmx edit? Other solution: 😉 https://giphy.com/gifs/reactionseditor-reaction-3o7btNRTJ700Vzmn5e

You could save the content of the edit in a variable and then first check if content has changed. And you could try if it makes a difference when you set the edit to "platform" or not.

At least I could tell them that the issue is related to Samsung. For the picture issue there were only a workaround (when you had still the pictures on android device): Copying the issued pic to a new empty folder with android file app and then copy this to windows. I by myself avoid Samsung galaxys and recommend other phones to peaple who ask me.

And the most strange issue I had with Samsung devices, was that when you copied a bulk of pictures to a windows device via USB, some pictures had the content of another picture. And we had links to such pictures in our database and the customer told us we are doing something wrong, showing the wrong pic. Difficult to find the issue...

In the past, when I had issues with my Android apps, it happned nearly only on some Samsung devices; so I thought already that it is the Samsung keyboard... Samsung can everything, besides software 😉

Have you tried another keyboard (gboard?) ?

First you should implement an exception handling and log it, for example: try //Get Command ... except on E: EIdHTTPProtocolException do Log('HTTP Error: ' + E.Message + ' (Code: ' + IntToStr(E.ErrorCode) + ')'); on E: EIdSocketError do Log('Socket Error: ' + E.Message + ' (Code: ' + IntToStr(E.LastError) + ')'); on E: Exception do Log('General Error: ' + E.ClassName + ' - ' + E.Message); end;

You should not use Delphi XE7 for Android 12. XE7 supports Android <= 4.4. https://docwiki.embarcadero.com/PlatformStatus/en/Main_Page

For us TS Plus works great.

I think tsplus webserver could do the job ...

The default behavior is the same since delphi 4, but since a few versions the optional "OldCreateOrder" property is ignored: https://docwiki.embarcadero.com/Libraries/Athens/en/System.Classes.TDataModule.OldCreateOrder

You could also try to create a select query and assign it to conection first and let it open until everything was done. This could avoid to the connection to the pool and unassign it.

How looks the code for the creation of the query?

What is the setting for Connection.ResourceOptions.KeepConnection ?

You could also try to enable ExtendedMetaData for connection.

What are your connection settings?

Do you have in your HTML part something like <img src="cid:FileName"> ?

You are using a Generator and a trigger? I thought you were using "generated by default as identity" for field in create table.

In Firebird 4 something like this could work: UPDATE OR INSERT INTO ESTDTL (EST_ID, ESTDTL_ID, CSC_ID, ESTDTLDSC, CSTPLS, GSTINC, GSTPCT, QTYCLC, QTY, CST, GST, SLE, VAL) OVERRIDING USER VALUE VALUES (:NEW_EST_ID, coalesce(:NEW_ESTDTL_ID, -1), :NEW_CSC_ID, :NEW_ESTDTLDSC, :NEW_CSTPLS, :NEW_GSTINC, :NEW_GSTPCT, :NEW_QTYCLC, :NEW_QTY, :NEW_CST, :NEW_GST, :NEW_SLE, :NEW_VAL) MATCHING (EST_ID, ESTDTL_ID) RETURNING EST_ID, ESTDTL_ID

The images are not visible to me. And what was the solution for your initial issue?

Therefore I have used MATCHING (EST_ID, ESTDTLDSC) (And maybe additional fields), because ID is created by DB after post. But maybe there is another solution using the id field...

Have you also provided values for "providerType", "isFolder", ...? See my JSON above.

I have no experience with Microsoft API, but that looks to me that you do not need to create a sharelink first, instead you can directly enter the file or folder as sourceUrl: { "post": { "body": { "contentType": "text", "content": "I attached a reference to a file on OneDrive." }, "attachments": [{ "@odata.type": "#microsoft.graph.referenceAttachment", "name": "Personal pictures", "sourceUrl": "https://contoso.com/personal/mario_contoso_net/Documents/Pics", "providerType": "oneDriveConsumer", "permission": "Edit", "isFolder": "True" } ] } }

And this was my fault: You had a "b.*", not an "a.*".

The modify SQL should look something like this: UPDATE OR INSERT INTO ESTDTL (EST_ID, CSC_ID, ESTDTLDSC, CSTPLS, GSTINC, GSTPCT, QTYCLC, QTY, CST, GST, SLE, VAL) VALUES (:NEW_EST_ID, :NEW_CSC_ID, :NEW_ESTDTLDSC, :NEW_CSTPLS, :NEW_GSTINC, :NEW_GSTPCT, :NEW_QTYCLC, :NEW_QTY, :NEW_CST, :NEW_GST, :NEW_SLE, :NEW_VAL) MATCHING (EST_ID, ESTDTLDSC) RETURNING ESTDTL_ID, ESTDTLMNTDTE