Also,
I found another problem after converting a table like:
TABLE LU_001
T_CODE INTEGER KEY NOT NULL
DESCRIPTION VARCHAR 128
into
TABLE LU_001
T_CODE SMALLINT KEY NOT NULL
DESCRIPTION VARCHAR 128
The table contained less than 10 rows of data, something like T_CODE had
from 0 to 6 used. I used Alter Table in SQL-Studio to change the type
from INTEGER to SMALLINT, but then later "select * from lu_001" returned
some rows, and an error something like "invalid data".
I even tried "delete from lu_001 where t_code = 4", etc. to remove the
rows that didn't show up. This seemed to work, but another query would
still show the error. Next, I just did "delete from lu_001", which seemed
to fix the problem.
Thank you,
Noah Silva
IS&T - Programmer Analyst
(215) 419 - 7916
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
