Solved

Change in Char Size

Posted on 2009-05-18
2
155 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Interactive Way of Training for the AWS CSA Exam

An interactive way of learning that will help you visualize core concepts so that you can be more effective when taking your AWS certification exam.  Built for students by a student to help them understand the concepts that they are being taught.

Question has a verified solution.

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

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

615 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