Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
create multiple records from a date range |
Sat, Apr 7 2007 10:30 PM | Permanent Link |
"Al Vas" | 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 |
Mon, Apr 9 2007 7:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Tue, Apr 10 2007 12:16 AM | Permanent Link |
"Al Vas" | 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 > |
Tue, Apr 10 2007 8:45 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |