Solved

Change in Char Size

Posted on 2009-05-18
2
153 Views
Last Modified: 2013-12-17
I have a backend Sybase Central, Front End MS Access 2000

I had a table tblBadge, there is a field in the table named "BadgeNo" Char (6), not null, unique.

Badge No starts with "W", I am now at W99999 so I changed Char size to 7 and relinked the tables. When i search through the front end I no longer get the records.

Example
I serach for W70000, no record
I add an extra 0 to the record W700000 and I get teh record.

It seems like now that I have added an extra value size to BadgeNo it is looking dfor an extra digit.

Help, confused
0
Comment
Question by:Brogrim
2 Comments
 
LVL 13

Accepted Solution

by:
kaylanreilor earned 500 total points
ID: 24411350
A '0' has been concatenized at the END of each existing record to match the new size.
Now you need a script that you have to run against your table to "move" this '0' just after the 'W'.
Former W71234 has become W712340 instead of W071234.
0
 

Author Comment

by:Brogrim
ID: 24411565
Whe you sday a script do you mean an append or update query
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question