Icon View Incident Report

Serious Serious
Reported By: Tiago Ameller
Reported On: 8/11/2005
For: Version 4.21 Build 8
# 2099 ALTER TABLE Not Working When Only LAST AUTOINC Value Specified

This SQL used to work for me in the past (4.19-4.21-b1 I don't remenber), but since update to 4.21-b7 does nothing, last autoinc value remains unchanged.

ALTER TABLE SFNUM043 LAST AUTOINC 444 NOBACKUP;

Here is code to create a sample table:

CREATE TABLE "SFNUM043"
(
  "Codigo" AUTOINC,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Numerador Cabeceras'
LOCALE CODE 0
USER MAJOR VERSION 1
);



Resolution Resolution
Fixed Problem on 8/11/2005 in version 4.21 build 8


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image