View Single Post
Old 12-29-2014, 05:02 AM   #31
Future Science
Member
Future Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura aboutFuture Science has a spectacular aura about
 
Posts: 23
Karma: 4388
Join Date: Jan 2013
Device: Kobo glo
Quote:
Originally Posted by PeterT View Post
Why not for the insert use the named column approach:

INSERT INTO user (UserID, UserKey, UserDisplayName, UserEmail, ___DeviceID) values(list of 5 values)

This way the syntax need not change as tables change.
Hi Peter,
I've tried to use sqlite only once, without much success.

Should I open a terminal (I'm on Linux), cd the directory of the Kobo squile file, then:
Code:
sqlite3> 
INSERT INTO user (UserID, UserKey, UserDisplayName, UserEmail, ___DeviceID) values(list of 5 values)
Am I correct?

I just want to remove my registered email address and give my Kobo Glo away.

Performing this operation is going to delete all my settings and books on the Kobo?
Future Science is offline   Reply With Quote