Friday, February 23, 2007

The autoincrement field

If you are setting an autoincrement field I council to do this with SQL Manager 2005 Lite for InterBase/Firebird. Edit the autoincrement field and in edit window, on thew left, at the voice Autoincrement>Initial value> put 0.
If the table contains data follow this procedure:

  1. Open the table with IBEasy
  2. In the window which appears clic on "data export "
  3. Export the table in XML or Excel format with IBEasy.
  4. Put the autoincrement field at the bottom of the other fields.
  5. Import with IBEasy the previous mentioned XML or Excel file.
  6. Now put the autoincrement field in the position which you want in the table.
At this point your table will have an autoincrement field with the records numbered.

No comments:

Post a Comment