|Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread|
|Messages 1 to 1 of 1 total|
|Dataset.Update + Dataset.Save - no data changed?|
|Thu, Jul 21 2022 5:52 PM||Permanent Link|
In a Server Application, I have a dataset "MapTrack" with two commands:
SELECT * FROM MapTrack;
UPDATE "MapTrack" SET
"ID" = :ID,
"SourceID" = :SourceID,
"Track" = :Track
WHERE "ID" = :Old_ID;
The table definition:
CREATE TABLE IF NOT EXISTS "MapTrack"
"SourceID" GUID NOT NULL,
PRIMARY KEY ("ID") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
So, it's the generated stuff. Then I try
if dsMapTrack.RowCount >0 then begin
dsMapTrack.Columns['Track'].AsString := 'test';
on e: exception do begin
Request.SendContent('All good, ID is ' + dsMapTrack.Columns['Track'].AsString);
I get no exception, error or anything else. But what I also don't get is the "test" string in the field "Track". The table has one record, and RowCount is larger than 0. I have put a Request.SendContent('', HTTP_OK, IntToStr(dsMapTrack.RowCount)); directly after the LoadRows and .Save to be sure.
It's the last thing I need to implement the last feature. But for that, I have to store some data.
Oh, and if anyone knows a way to define a command on the server side and call it with parameters from the client, I'd be thankful I would not need the server application if something like that would be possible.