Hi

I'm using edb 2.02 b1

I have a DbIsam 4 table ,  

* call a Migration procedure.

no error message

but the table is corrupt, already.

if i call ALTER COLUMN "FIELD5" MOVE TO 1 , wrong position
and i see field5 in 2' position.

if i use edbmanager and move ( drag e drop ) 3' column to 2' position ,
i see in SQL HISTORY : MOVE TO 1   -.-





i'm studing this problem..

Hi

I have much problems of KeyViolation on SQL Alter table... ( in temporary
table MYPCNAME_TABLENAME)

i'm reintalling 2.01B5....

i'm studing this problem..

Mauro,

<< I have much problems of KeyViolation on SQL Alter table... ( in temporary
table MYPCNAME_TABLENAME) >>

Did you verify that it isn't this issue ?

http://www.elevatesoft.com/incident?action=viewaddr&category=edb&release=2.02&type=f&incident=2813

--
Tim Young
Elevate Software
www.elevatesoft.com

hi

after 6 hours of test  i found the cause.

I must change a lot of code for use EDB 2.02 B1 from edb 2.01B5

The problem :

i make much query for Alter Table , add index , and there too much error of
Keyviolation / contraits , in Edb 2.02

i have try to back at edb 2.01 and all work well.
but i have the problem of the cancelrange in this version...


my query ( remove of old recordID and any change positions.. )

ALTER TABLE crmattivita  DROP CONSTRAINT PrimaryKey, DROP COLUMN RecordID,
ALTER COLUMN "CODICE" MOVE TO 1, ALTER COLUMN "DATA_INS" MOVE TO 2, ALTER
COLUMN "ORA_INS" MOVE TO 3, ALTER COLUMN "OPERATORE_INS" MOVE TO 4, ALTER
COLUMN "CODICE_ANAG" MOVE TO 5, ALTER COLUMN "TIPO_ANAG" MOVE TO 6, ALTER
COLUMN "ANAGRAFICA" MOVE TO 7, ALTER COLUMN "DATA_INIZIO" MOVE TO 8,
.......................
ALTER COLUMN "CODICE_CAMPAGNA" MOVE TO 40,
ALTER CONSTRAINT "CODICE" AS UNIQUE  ("CODICE")

ALTER INDEX  "TIPO_ANAG_DATA_INIZIO" ON "crmattivita"
( TIPO_ANAG COLLATE ANSI_CI ASC,CODICE_ANAG ASC,DATA_INIZIO DESC,ORA_INIZIO
COLLATE ANSI DESC )

don't work , more.

I must to seperate in 2 distinct query this work

1) remove RECORDID and RECORDID contraits
after !!!!
2) change / update field structure

in edb 2.01b5 ,i can do this 2 query all toogether
in edb2b1 i must operate in 2 distinct time

For me the problem is :

edb2 wrong or have change  index field order when i drop  constraint or
PrimaryKey.
then all the operations on fields index don't work more.

Best Regards.
Mauro Botta.

Mauro,

<< I have a DbIsam 4 table ,

* call a Migration procedure.

no error message

but the table is corrupt, already. >>

Send me the table, please.  The DBISAM 4 migration is tested in the
automated test framework, so there must be something specific about your
source table that is causing an issue.

<< if i call ALTER COLUMN "FIELD5" MOVE TO 1 , wrong position and i see
field5 in 2' position.

if i use edbmanager and move ( drag e drop ) 3' column to 2' position , i
see in SQL HISTORY : MOVE TO 1   -.- >>

I'm not seeing either of these issues here with 2.02 B1.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mauro,

<< i make much query for Alter Table , add index , and there too much error
of Keyviolation / contraits , in Edb 2.02 >>

Did you not read my response regarding this yesterday ?

<< I must to seperate in 2 distinct query this work >>

Please send me the table (and database catalog) that you're altering with
this statement.  I'm having a hard time understanding what the problem is
that you're seeing, so I'm going to just have to try it here and see if I
can figure out what it is that you see as the problem.

--
Tim Young
Elevate Software
www.elevatesoft.com