TMSFNCPlanner DatabaseAdapter Item Text max 255 characters

[Stapel_Andreas]

I use Aurelius in conjunction with the TMSFNCPlanner and TMSFNCPlannerDatabaseAdapter.
I create the text of an appointment via a virtual database field and the "function GetAppointmentText: string"
For this purpose, there is the property "appointment_text".
In the TMSFNCPlannerDatabaseAdapter, I pass appointment_text to "Item.text".
Although the text was created completely.
But when I start the program, only the first 255 characters of the generated text are displayed in the planner items.

[wlandgraf (Wagner Landgraf)]

@Stapel_Andreas

For this purpose, there is the property "appointment_text".

Have you checked the content of this property right after you load it from database? What is the mapping of this property/field?

By default, string properties in Aurelius are mapped as VARCHAR, and by default the length of such field is 255, so my guess is that you are simply saving a value that is longer than your underlying database structure supports.

If you want to save text with "unlimited" size with Aurelius, better map it to a TBlob property or map the column to have 65536 chars:

Aurelius Entity Memo Field and XData-Server as REST Server / expanded

In this case I recommend you simply change your mapping from TBlob to string and set the size to 65536: [Column('Anschrift',[],65536)] FAnschrift: string; This way, lazy-loading will not apply and the string in JSON will come as pure string.

or:

Load Image from a Blob DataField (Base64)

If you could send a project that reproduces the issue, that would be helpful. In any case, if you are always going to save text content in the blob field, add the attribute DBTypeMemo (or DBTypeWideMemo) to your mapping so Aurelius knows it's a memo field: [DBTypeMemo] [Column('logo', [TColumnProp.Lazy])] Flogo: TBlob; In the dataset, also try to treat it as a memo (or widememo) field.