Hi Sir,
I found it and replace my type to Integer(AutoInc). However, after I inserted the info, it puts 1 on userid instead of 8. Please help.
OPEN DATABASE testdata
SELECT 0
USE testusers
INSERT INTO testusers(username, userfullname) ;
VALUES(lcUserName, lcFullName)
Thanks,
Sam