Home Forums SQL Server 7,2000 Performance Tuning Doubling up of Alpha numeric password RE: Doubling up of Alpha numeric password

  • June 5, 2013 at 9:42 am

    #1621396

    glycere2000 (6/5/2013)

    I have a vb6 application and the database is housed on an SQL2000 server. My problem is that the vb6 function should increment the numeric form of the ID and then affix the prefix alphabeth aprt to it but strangely i'm getting duplicate ID fields. Once or twice i've had to manually change the ID to what it should be. Could it be because i am doing this?

    You'll need to provide some more details to get a decent answer;

    offhand, from what you said it sounds like the vb6 function should increment the numeric form of the ID doesn't generate a unique value.

    actual examples would help, but i'm thinking the issue is there.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!