Hi,
I face a problem when I want to use SQLite database file stored on webpage to select and update data. My situation is following:
- I have SQLite database file database.db, where is one table (MyTable) with three text columns: ColA,ColB, ColC. There is no password protection in the file.
- I have webpage, let's say www.abcd.com, where is stored my SQLite database file (www.abcd.com/folder/database.db).
- I am connecting to the files in the webpage through FTP (using FTP.Initialize("FTP", "www.abcd.com", 21, "MyUserName", "MyPassword")).
- Now I want to perform select from database.db: select ColA, ColB from MyTable - the question is: how to?
I tried to use the RDC tutorial, but I don't know what to put where and how
I downloaded RDC files, I downloaded file sqlite-jdbc-3.7.2.jar and put it to jdbc_driver folder, I changed file config.properties:
Please, how should I force my app to connect to my webpage, select data from database.db and display it inside of app?
Thank you for help.
I face a problem when I want to use SQLite database file stored on webpage to select and update data. My situation is following:
- I have SQLite database file database.db, where is one table (MyTable) with three text columns: ColA,ColB, ColC. There is no password protection in the file.
- I have webpage, let's say www.abcd.com, where is stored my SQLite database file (www.abcd.com/folder/database.db).
- I am connecting to the files in the webpage through FTP (using FTP.Initialize("FTP", "www.abcd.com", 21, "MyUserName", "MyPassword")).
- Now I want to perform select from database.db: select ColA, ColB from MyTable - the question is: how to?
I tried to use the RDC tutorial, but I don't know what to put where and how
I downloaded RDC files, I downloaded file sqlite-jdbc-3.7.2.jar and put it to jdbc_driver folder, I changed file config.properties:
B4X:
DriverClass=org.sqlite.JDBC
JdbcUrl=jdbc:sqlite:http://www.abcd.com/folder/database.db
User=
Password=
ServerPort=17178
Debug=true
#commands
sql.select_statement=SELECT ColA, ColB FROM MyTablePlease, how should I force my app to connect to my webpage, select data from database.db and display it inside of app?
Thank you for help.