'Variable length column overflow whe using TFDLocalSQL

I try to query a clientdataset (cdsSource) with TFDLocalSQL. The clientdataset has persistent fields, some are stringfields, size 1. I do a select * from cdsSource , and get an error : "Variable length column overflow".

I found the cause and the solution, but think this is not the way it should be:

The error occurs when the order of the field in the query is different from the order of the persistent fields.

I think the following picture is self-explaining. It is clear that the data of column "volgnummer" is assigned to the field "NietOpLaadLijst"

enter image description here

the question is : Is this by design ? Or is it a bug ? Whatever it is, it is extremly confusing .

kind regards,

Dirk Janssens.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source