ckroon
Posts: 869
|
| Posted: 05/01/2008, 2:01 PM |
|
Hi All..
I am trying to duplicate a slow, Access-based textbook inventory database component.
Textbooks are stored as such: Textbookid='00001 textcopyno='000002 etc
The barcodes on the books say: Book: 01 Copy: 02
When searching for a text by its book and copy number, I want to avoid having the user input all the leading zeroes.
I have tried formatting the textbox in the search grid to be #####, with no luck.
Any suggestions?
_________________
Walter Kempees...you are dearly missed. |
 |
 |
DonB
|
| Posted: 05/01/2008, 4:58 PM |
|
CAST (SQL function) the data, which evidently is CHAR or VARCHAR, into an
INTEGER data type (approximate syntax is: SELECT CAST (somevalue as INTEGER)
FROM sometable) in your query, so the data CCS sees is a number. That will
eliminate the leading zeros and no custom event code is required.
--
DonB
"ckroon" <ckroon@forum.codecharge> wrote in message
news:5481a2f9be7255@news.codecharge.com...
> Hi All..
>
> I am trying to duplicate a slow, Access-based textbook inventory database
> component.
>
> Textbooks are stored as such: Textbookid='00001 textcopyno='000002 etc
>
> The barcodes on the books say: Book: 01 Copy: 02
>
> When searching for a text by its book and copy number, I want to avoid
> having
> the user input all the leading zeroes.
>
> I have tried formatting the textbox in the search grid to be #####, with
> no
> luck.
>
> Any suggestions?
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
|
