If the ID field is created as an identity field, then u will have to reset the identity to the last used value so that the next generated ID will be ur free one.
This is the syntax for MS SQL databases.... dbcc checkident(table_name, value, "reseed") dont know the syntax for oracle db. On Mar 11, 8:42 pm, Imgine R <[email protected]> wrote: > Hi, > > Currently working in AIR project. Im facing a problem with DELETE sql > statement. To empty the DB use DELETE statement | DELETE FROM tablename| . > The values in the table are deleted but it is not removing the index(My > guess). Because of that when i try to insert a new value its add from the > last index. How to solve? > > Thanks, > Imgsrn -- You received this message because you are subscribed to the Google Groups "Flex India Community" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/flex_india?hl=en.
