Using Sqlite with Application Studio

[Markus77]

Hello, I am on the learning journey "Develop Applications Running on SAP BTP Using SAP HANA Cloud". Using the Application studio with Sqlite to start with and have imported the data sets given. Everything seems to be working alright (npm install, cds build and deploy ...) but when running the application and switching to the web preview no data are shown but only the first ID-column of the data sets and all other data are "null". Could the problem be related to the Sqlite version 3 or earlier? Help much appreciated 🙂.

[Margit_Wagner]

Hi @Markus77
I informed the subject matter experts they will look into this.

Kind regards
Margit

[Markus77]

Thanks to Ancutas description, it's now working 🙂 - thank you very much!

I changed the package.json as follows and ran npm install, cds build and cds deploy.

cds watch does the magic in the background.

After marking the relevant data-columns, the tables are reproduced in the fiori preview: