Hi,

I have a requirement to take a record that has a from and to date and create
individual records for each date in that range.  For example:

a record 3/3/07 to 7/3/07
resultant set needs to contain 3/3,4/3,5/3,6/3,7/3.

Can this be achieved (multiple statements k) using V3.30?

Thanks

Alex

Alex,

<< Can this be achieved (multiple statements k) using V3.30? >>

It it could be, it would probably be unreadable.  I think you'll need a
looping construct to do what you want, and the scripts in 3.x can't do that.

--
Tim Young
Elevate Software
www.elevatesoft.com

K leads to the next question, can 4.x do it?

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:882FA6D7-70D5-45BA-997C-B8B8C6F619A4@news.elevatesoft.com...
> Alex,
>
> << Can this be achieved (multiple statements k) using V3.30? >>
>
> It it could be, it would probably be unreadable.  I think you'll need
> a looping construct to do what you want, and the scripts in 3.x can't do
> that.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Alex,

<< K leads to the next question, can 4.x do it? >>

No, but EDB can with a stored procedure.  And it will be able to do so with
a script within the next month or so.

--
Tim Young
Elevate Software
www.elevatesoft.com