Eddie B
Guest
|
 Posted:
Sat Nov 12, 2005 9:01 am Post subject:
WHY: duplicated entries in suppliers table after using QSimp |
|
|
hello
after using QSimport to populate the items table, i've noticed that there
are a lot of duplicate entries being created in the supplier table. There are
254 only distinct supplier names, but there are 654 suppliers total. When you
look at the suppliers which are present more than once, you notice (i am 99%
sure) that all of the ones that get duplicated are had to be truncated to 30
characters, the max data length for that field. i checked and they are not
being duplicated because they are misspelled or even because of trailing
spaces in the supplier name
1) would it be harmful to increase the data length to 50?
2) why is this happening?
Thanks,
Eddie B
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in
