Hege B4878

Member since: Wednesday, 08 April 2015
Last login: 3 years ago
Profile viewed: 477 views

Your Rank: 93
Points: 1

Hege B4878 replied to the topic 'Batchupdate with TFDQuery' in the forum. 3 years ago

I already added the project for you. But here you go again.

File Attachment:

File Name: TestFDQuery_2018-08-31-2.zip
File Size: 55 KB


Hege B4878 created a new topic ' Batchupdate with TFDQuery' in the forum. 3 years ago


I'm having trouble getting TFDQuery to behave. In my example project, I have a simple SQL database, with a single table called Trans. This table has 2 columns, TransId and Msg. We add two records to this table, where Msg is NULL in the first record. TransId is an autoinc int column.

qrySelect selects the two records ordered by TransId, so that the record with Msg = null is the first record. We then use qryUpdate to update the two records in Trans with the same values as they already have. When this is done, Msg in my second record is nulled! Why is that?

The database is created with the query below.

USE [Test]
CREATE TABLE [dbo].[Trans](
[TransId] [int] IDENTITY(1,1) NOT NULL,
[Msg] [text] NULL

insert into Trans(Msg) values(NULL)
insert into Trans(Msg) values('This is a text')


Hege B4878 posted a comment on RAD Studio 2015 Roadmap 7 years ago

When will you focus on upgrading the Compiler for Delphi? We need lambda expressions with syntax like C#, better linking of Generics and autoguid attribute for interfaces (for generic interfaces).