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:

[ancutamezi]

Hi  ,It should, this is not related to the Sqlite version. In your package.json you should have: "devDependencies": { "sqlite3": "^5.0.2" }, where ^ - means taking the latest version of sqlite. The steps for testing it locally are:

1. npm install or npm update

2. cds build

3. cds deploy

4. cds watch:

5. Open the localhost, go to Fiori preview:

6: If you can't see the fields, please navigate to Settings and add all the columns you want to see.

Hope this helps, if not please let me know.

Best regards,

Ancuta

@Markus77

[Markus77]

Hi Ancuta, thank you very much! I will try and give you feed-back.