Question Re: Using Sqlite with Application Studio in SAP Learning Q&A

Using Sqlite with Application Studio

Markus77 — Mon, 28 Aug 2023 09:11:49 GMT

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 🙂.

Re: Using Sqlite with Application Studio

Margit_Wagner — Fri, 01 Sep 2023 11:08:27 GMT

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

Kind regards
Margit

Re: Using Sqlite with Application Studio

ancutamezi — Tue, 05 Sep 2023 09:40:28 GMT

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

Re: Using Sqlite with Application Studio

Markus77 — Tue, 05 Sep 2023 11:21:55 GMT

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

Re: Using Sqlite with Application Studio

Markus77 — Tue, 05 Sep 2023 16:05:34 GMT

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: