Olli73

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

The database file is missing...

And ARequest := arInsert; ARequest is no var parameter, so changing should have no affect!?

And is this condition true on insert: if (ARequest = arUpdate) and (ASender.FieldByName('EstDtl_ID').IsNull) then Normally it should be insert and not update for new record and the estdtl_id is not in the query, so that should raise an ecxception!?

In the query I would include the b.ESTDTL_ID to have a unique ID for "ESTTDL table" and in the insert I would set b.est_id to a proper value. What is the content if this est_id field? Can it be null?

When I understood you right, you have problems with inserting new records !? How looks your "TFDUpdateSQL.InsertSQL" ?

At least createCompomponents should not be synchronized so that components gets created in thread context.

Do you want to print under Windows or mobile phone? Under Windows you can follow the approach from Vincent. A printer driver must be installed under windows for that. Under mobile phone you should connect via bluetooth to the printer, establish a communication channel and send data in the "printer language" to the printer.

ConvertThreadToFiberEx is a WinAPI function which exists since Windows Vista, so it cannot work under XP.

Isn't it so that the IdContext is freed on connection loss and so I have no reference anymore to my data on reconnect? Then he could save the data reference in a dictionary (do not forget to use a locking mechanism) with IP address or any Unique Client ID as key and restore the data reference on reconnect.

Therefore I asked if it is Samsung! Samsung can everything except software! 😚

Then setting the control type to platform should work, as I have mentioned.

Happens that only in Delphi Apps? Then try to set the control type to platform for the edit. When it happens in all apps, which smartphone do you use? Samsung?

Is 32 / 64 bit matching between your app and webview?

Try a Select Sum(Round(Price * Qty, 2)) as Total or Select Round(Sum(Price * Qty), 2) as Total And what is the FieldType in ClientdataSet?

Try Bitmap32 from https://github.com/graphics32 TBitmap is not Threadsafe in most cases.

Is at this place something filled in "restResponse1.Content"? Is the value later (after the Handler) filled? And what is the StatusCode of the response?

In case of ExecuteAsync, have you used the ACompletionHandler Parameter instead of the Afterexecute event and also set the ASynchronized Parameter to true?

Instead of creating your own thread/task, you could/should use "RestRequest1.ExecuteAsync(...)".

Do you use a DLL and have also in Windows event log something with "KERNELBASE.dll"? I could only solve such an issue by including the DLL code into program.

Download works out of the box, upload not. You must have a PHP Script, a CGI, a ISAPI dll or an own server to be able to upload files.

What did you install / configure on Apache server side to accept uploading files?

Not much information. I would also create a logging in the ISAPI dll.

Not sure, my experience with IIS is a long time ago, but it could be here: %SystemDrive%\inetpub\logs\LogFiles