OnStart ClearCollect from SQL table - no content loaded

[DIECKBE]

Hello there,

I have quite some trouble to load data from a SQL-Table to a collection.

OnStart I use the following: ClearCollect(dimLeiter;'[inspdeve].[winlineprodukteleiter]')

Issue is, that the coumnnames are loaded correctly, but the contect is not loaded.

Any idea how to solve it? Database is a MariaDB

Thanks and regards

Benny

[PTBBSolutions]

Hi @DIECKBE ,

Can you try using the Screen's OnVisible property and not the App OnStart?

[DIECKBE]

Unfortunately the same result. Labels are loaded correctly, but the content is missing.

I'm using a dropdown to test it. Items are dim_leiter.LeiterHersteller.
LeiterHersteller is underlined blue with the following message:

Warning. The columns generated by this rule are all nested tables and / or records, but the property expects at least some columns with simple values (such as text or numbers).

Do you know what it means?