Subject RE: [ib-support] Initializing arrays
Author Ann W. Harrison
>
> > I have a table with an array declared as:
> >
> > Create Table xxx(
> > ...
> > HoursArray Float [1:50,1:5],
> > ...);
>
>I've never used arrays, nor do I know of many people who have, but have
>you tried using the DEFAULT syntax, as in:
>
>Create Table xxx(
> ...
> HoursArray Float [1:50,1:5] Default 0,
> ...);


Unfortunately, although the syntax Sean suggested is
accepted, the result doesn't work. I guess I have
two questions. Why are you initializing the array
to zero? Why not leave it null if you don't have
values for it?

The bad news is that if you want to initialize the
array, you'll have to do it explicitly on the client
side.


Regards,

Ann
www.ibphoenix.com
We have answers.