My table in sqlite has column 'name' which takes input like prefix+integervalue. for example p1, p2. and if there are 5 rows p1, p2, p5, p7, p10. I know the input prefix as 'p' and my next insert value must be p3 after that p4, after that p6,p8,.. like that. please help me for a query to find this gaps or any API support, I am using content_provider in android programming. Please help me my client needs this..
Aucun commentaire:
Enregistrer un commentaire