topic Re: general in Application Development and Automation Discussions

general

Former Member — Tue, 08 May 2007 09:01:13 GMT

i am trying to create emloyee table if we give sno as char it is not showing any error but if we give it as integer then it is showing error why is it happening so can u plz tell me the reason.what is the diff between char and integer.

Re: general

Former Member — Tue, 08 May 2007 09:03:12 GMT

Hi,

the diffence is, that int is only used for numbers and if you want to calculate with it. Char is only a text field with a special lenght.

Regards

Nicole

Re: general

Former Member — Tue, 08 May 2007 09:08:40 GMT

Hi Manjula,

depending upon ur requiremnet, u can go for CHAR or INTEGER for a field of ur database table. as for ur case, the serial number field, "SNO" can be either character or integer. it's ur choice.

is u use INT1, the length is predetermined to be 3,

INT2 - 5 length

INT4 - 10 length.

hope it will work now in INT datatype.

thanks,

viji.

Re: general

Former Member — Tue, 08 May 2007 09:10:06 GMT

Hi Manju,

What error r u getting? can u specify?

CHAR: Character string. Fields of type CHAR may have a maximum length of only 255 in tables. If longer character fields are to be used in tables, you must choose data type LCHR. There are no restrictions on the length of such fields in structures

INT1: 1-byte integer between 0 and 255. The length is set to 3 places for this data type.

INT2: 2-byte integer between -32767 and 32767. Fields of this type should only be used for length fields. These long fields are positioned immediately in front of a long field (type LCHR, LRAW). With INSERT or UPDATE on the long field, the database interface enters the length which was actually used in the length field. The length is set to 5 places for this data type.

INT4: 4-byte integer between -2147483647 bis 2147483647. The length is set to 10 places for this data type.

Rgds,

Prajith

Re: general

Former Member — Tue, 08 May 2007 09:12:07 GMT

Character and Integer fields are entirely different. Character is of length 1 by default. You can declare as of lenght you want.

It might be giving an error in your case may be because you might be declaring the lenght as something other then the default lenght ... may be that is the error ... please try to remove the length you have declared and it will take the default length.....

May be this will solve the problem

Regards,

Jayant

Re: general

Former Member — Tue, 08 May 2007 09:12:25 GMT

Hai,

If First time Sno is created as char type, after activating, if you try to modify it as int type it gives error.

Solution:

At the Menu in database tables: Go to ~~>Utilities~~>Database utilities-->Adjust and activate database.

Hope this solves your problem.

Regds,

Rama chary.Pammi

Re: general

Former Member — Tue, 08 May 2007 09:20:42 GMT

hi viji,

is u use INT1, the length is predetermined to be 3,

INT2 - 5 length

INT4 - 10 length.

do u mean that if we declare int1 it accepts only 3 characters.plz help me to understand.