cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
A New Home in the New Year for SAP Community!

Using Sqlite with Application Studio

Markus77
Galactic 1
Galactic 1
0 Kudos

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
Employee

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

Kind regards
Margit

 

Answers (2)

Answers (2)

Markus77
Galactic 1
Galactic 1

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.

Markus77_1-1693929437574.png

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

Markus77_0-1693928546063.png

 

 

ancutamezi
Employee
Employee

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

Screenshot 2023-09-05 at 12.35.51.png

Screenshot 2023-09-05 at 12.32.50.png

Screenshot 2023-09-05 at 12.37.26.png

@Markus77

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