How Can I assign a sequence value to a sqlite field when the field UID value is NULL
- by Registered User KC
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!