How Can I assign a sequence value to a sqlite field when the field UID value is NULL

Posted by Registered User KC on Stack Overflow See other posts from Stack Overflow or by Registered User KC
Published on 2010-06-12T09:44:57Z Indexed on 2010/06/12 9:53 UTC
Read the original article Hit count: 317

Filed under:

sqlite

|

alternative

|

autoincrement

|

manual

|

unique-key

Hi All,

How I can assign a sequence value to a field "UID" which is NUll in existing sqlite table, for example

table: FOO  
name    UID
A   1
B   2
C   100
D   NULL
E   NULL
F   NULL

what I want is

table: FOO  
name    UID
A   1
B   2
C   100
D   101
E   102
F   103

Can some body help? I want to seek an alternative for using autoincrement on my own reason...

thanks!

© Stack Overflow or respective owner

Related posts about sqlite

How to add SQLite (SQLite.NET) to my C# project

as seen on Stack Overflow - Search for 'Stack Overflow'
I followed the instructions in the documentation: Scenario 1: Version Independent (does not use the Global Assembly Cache) This method allows you to drop any new version of the System.Data.SQLite.DLL into your application's folder and use it without any code modifications or recompiling… >>> More
dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

as seen on Stack Overflow - Search for 'Stack Overflow'
Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)? >>> More
SQLite table does not exist exception for existing SQLite database (and table)

as seen on Stack Overflow - Search for 'Stack Overflow'
I've followed the instructions given here for introducing an existing SQLite database to your Android app. When I query the table "android_metadata" this is fine. But when I run a similar query on my own table "words" (which has _id for primary integer key) I get a table does not exist exception… >>> More
Android Jelly bean database is locked (code 5)

as seen on Stack Overflow - Search for 'Stack Overflow'
Im getting a database is locked (code 5) in my ListActivity the code works in the other versions of the Emulator but fails in the 4.1 version of the emulator E/SQLiteLog( 2132): (5) database is locked E/SQLiteDatabase( 2132): Failed to open database '/data/data/id.online.mydroid/databases/geo… >>> More
Android:accessing assets folder sqlite databse file with .sqlite extension

as seen on Stack Overflow - Search for 'Stack Overflow'
How to read data from the assets folder sqlite database file with .sqlite extension in my android application? Thanks >>> More

Related posts about alternative

Best methods for Lazy Initialization with properties

as seen on Programmers - Search for 'Programmers'
I'm currently altering a widely used class to move as much of the expensive initialization from the class constructor into Lazy Initialized properties. Below is an example (in c#): Before: public class ClassA { public readonly ClassB B; public void ClassA() { B = new ClassB(); … >>> More
Can I still use unity 2d [duplicate]

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
This question already has an answer here: Is it possible to change Unity 3D to 2D and will I gain any performance boost after that? 3 answers I can not run unity 3d on my Chromebook… >>> More
Microsoft OneNote alternative?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Hi folks! Is there any program for Linux that has about the same functionality and usability as Microsoft OneNote? At the moment I am checking out Basket (for KDE), that seems to point to the right direction, but still lacks much of the functionality of OneNote and is very buggy unfortunately. For… >>> More
Native, FOSS GUI prototyping tools?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
As part of my job as a web developer, I spend an amount of time doing UI prototypes to show the client. It's a pain in the behind but sometimes it has to be done. I've seen Shuttleworth (and the design team) pump out images like this: That's made by something called Balsamiq Mockups... Something… >>> More
Is there a way to update all Java related alternatives?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Is there a way to quickly switch over all the Java related alternatives using update-alternatives? For instance, if want to switch Java over to 7, I run sudo update-alternatives --config java and select the Java 7 OpenJdk. But if I run update-alternatives --get-selections | grep java I get the following… >>> More