Solved

Change in Char Size

Posted on 2009-05-18
2
152 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

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
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:…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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