<div>
Whe you sday a script do you mean an append or update query
</div>


Whe you sday a script do you mean an append or update query

<div>
<div class="content wysiwyg-content">
I have a backend Sybase Central, Front End MS Access 2000<br />
<br />
I had a table tblBadge, there is a field in the table named &quot;BadgeNo&quot; Char (6), not null, unique.<br />
<br />
Badge No starts with &quot;W&quot;, 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.<br />
<br />
Example<br />
I serach for W70000, no record<br />
I add an extra 0 to the record W700000 and I get teh record.<br />
<br />
It seems like now that I have added an extra value size to BadgeNo it is looking dfor an extra digit.<br />
<br />
Help, confused
</div>
</div>


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

Change in Char Size

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.