Main Site Documentation

SQLite in Chipworkx


#1

how do you make a database in Chipworkx using SQLite?


#2

Welcome to the forum!

Have you read GHI SDK documentation?

http://www.ghielectronics.com/downloads/NETMF/Library%20Documentation/html/4721d1ba-2d0a-8ace-ff30-5dbb58566e74.htm


#3

Not yet. I am actually new to NETMF. I actually need to put a database in Chipworkx for our thesis.


#4

It is pretty straightforward. Try it out and if you’ll stuck we here to help. There is also handy wrapper
http://code.tinyclr.com/project/192/sqlite-wrapper/


#5

Thanks… I’ll go try it now.


#6

What happened? An error occured when i tried to run the wrapper…


#7
  1. Is your firmware and SDK up to date and match each other?
  2. Remove and re-add references and then rebuild wrapper and test app.

#8

I’ve downloaded the SDK just last month. I’d already remove and re-add the references back but the error is still there.


#9

What is your firmware version on the device?


#10

4.1.7.0


#11

I still get an error with the wrapper…why is that?


#12

You are running on the device not emulator, right?


#13

Im running it in the emulator. The device is with my group mate and is also trying the wrapper…


#14

It has to be on the device. It will not work in the emulator.


#15

ok…i’ll try it with the device later…Thanks. :slight_smile:


#16

You are welcome! :smiley:


#17

is it possible to create a view or stored procedure in sqlite?


#18

Check if this is supported in the sqlite documentation. If it is then it should be working on Chipworkx as well.


#19

I am having an error with my view whenever its getting data from multiple tables… how do you make a view in sqlite?


#20

You need to read about it in the sqlite documentation.