Hi Now we cannot change the field type. Because already our application is running and thousands of records are already entered. we are getting same no for clipid when 2 users are entering data at a time. so how to solve the problem
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend