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:
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 MyTable
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.
