I think this is a great idea.


...pat

-----Original Message-----
From: Ann Harrison [mailto:harrison@...]
Sent: Tuesday, November 07, 2000 11:56 AM
To: IB-Architect@egroups.com; 'IB-Architect@egroups.com'
Subject: RE: [IB-Architect] System table change


At 11:41 AM 11/7/2000 -0500, Griffin, Patrick J. wrote:

>So,
>
>create table test1 (
> field1 integer,
> field2 numeric(9),
> field3 decimal(4,2));
>
>They are all integers, but
>
>field1 gets a subtype of 0
>field2 gets a subtype of 1
>field3 gets a subtype of 2
>
>Do I understand this correctly?

Right. And the purpose is to make it possible for
interfaces like ODBC, IBO, etc. to handle numbers
better. When we keep precision, we can also enforce
the limits of the numeric type (another great leap
backward toward standards).

Regards,

Ann


To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com