Proxy connection problem

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

Proxy connection problem

Postby jagtap.jj1 » Tue Sep 30, 2008 12:35 pm

Hello everybody

I am using following command, encountering following error ,

E:\jagtap\Andriod SDK\android-sdk-windows-0.9_beta\tools>adb shell sqlite3 /data
/data/com.google.android.providers.settings/databases/settings.db "\"INSERT INTO
system VALUES(99,'http_proxy',' 192.168.10.200:808');\""
Syntax error: "(" unexpected



If any body have the solution plz reply me.


Regards
Jagtap Jalandar

mail ;
java-android developer
User avatar
jagtap.jj1
Senior Developer
Senior Developer
 
Posts: 124
Joined: Fri Aug 22, 2008 11:52 am
Location: India(Mumbai)

Top

Postby ninor » Tue Sep 30, 2008 9:58 pm

Your SQL statement lacks the column names before VALUES.
That's the (column-list) parameter here:
Code: Select all
INSERT [OR conflict-algorithm] INTO [database-name .] table-name [(column-list)] VALUES(value-list)


More explanation: you have to specify the column names used in the values list.
User avatar
ninor
Moderator
Moderator
 
Posts: 180
Joined: Thu Aug 14, 2008 6:30 pm
Location: Barcelona, Spain

Top

Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 6 guests