Number field as '0003' not '3' 
Author Message
 Number field as '0003' not '3'
        I found out as I was going through my data in my dbase that all my number fields that did not start with a solid number (1 thru 9), came out "short".  If I want a number field to be 4 digits long, how do I get that regardless of whether the user puts in "3" ( I would like "0003")  

Thanks,
Sean



Mon, 12 Mar 2001 03:00:00 GMT
 Number field as '0003' not '3'

Lots of questions.
1.  Why?
2.  Is this for output from the database? If so then use the
to_char(xxx,'0999') to format the number.
3. Is this number used in calculations? If not define it as a CHAR (or
VARCHAR2) length of 4 and validate the number as 4 long on input.

With out knowing the needs and purpose of your application, it is difficult
to answer the question.

HTH
   James


Quote:

>        I found out as I was going through my data in my dbase that all my

number fields that did not start with a solid number (1 thru 9), came out
"short".  If I want a number field to be 4 digits long, how do I get that
regardless of whether the user puts in "3" ( I would like "0003")  
Quote:

>Thanks,
>Sean

--

                              |   real and imaginary parts


Mon, 12 Mar 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. **************!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Help me !!!!!!!!!!!!!!!!!!!!!!!!'''''''''''''''''''''''*************

2. type field ''money''

3. It's not ODBC - It's not ASP - It's OLE/DB

4. Field 'xxxxx' not fount

5. Query:Field 'fieldname' not found

6. Field 'PHYSICALTYPE' not found

7. 'This field is not modifiable'

8. HELP - VARIABLE 'field name' NOT FOUND

9. 'field' phrase not found (dropdown box)

10. like '%' not return null's

11. Creating RunTime Fields: EDataBaseError 'Field 'Fieldname' is not of the expected type'

12. sp_dboption 'sli', 'concat_null_yields_null', 'false' does not work properly


 
Powered by phpBB® Forum Software