RE: [sqr-users] Renaming oubound file

["Carlton Conley" <cconley@cdg-inc.com>]

doesn't really matter how long the extension is, but I would guess you need
to close the file before you can rename it

-----Original Message-----
From: sqr-users-bounces+cconley=cdg-inc.com@sqrug.org
[mailto:sqr-users-bounces+cconley=cdg-inc.com@sqrug.org]On Behalf Of
radhika reddy
Sent: Wednesday, November 17, 2004 2:44 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Renaming oubound file




it's not after extension. it is like this training17112004.txt.

LET $SYSTEMDATE = EDIT(SUBSTR($sysdatetime,1,11),'MMDDYYYY')
display $SYSTEMDATE                                 ! here i am able to get
11172004
LET $NEW_FILENAME = $File2 || $SYSTEMDATE
let #ret_cd = rename($File2,$NEW_FILENAME)
   if #ret_cd <> 0
      show 'Error Renaming ' $File2 ' to ' $New_fileName ' Ret_cd = '
#ret_cd
  end-if

where my $file2 is 'C:\Documents and Settings\lkra\Desktop\Training.txt'.

I am getting the following error:-

ERROR Renaming C:\Documents and Settings\lkra\Desktop\Training.txt to
C:\Documents and Settings\lkra\Desktop\Training.txt11172004 Ret_cd =
13.000000


>From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
>Reply-To: "This list is for discussion about the SQR database
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "'This list is for discussion about the SQR database
>reportinglanguagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Renaming oubound file
>Date: Wed, 17 Nov 2004 11:23:15 -0800
>
>You can't append the date to the end of the file name; extensions are only
>three characters.  You want to insert the date before the last period in
>the
>filename string.
>
>-----Original Message-----
>From: radhika reddy [mailto:radhika_05@hotmail.com]
>Sent: Wednesday, November 17, 2004 11:19 AM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] Renaming oubound file
>
>
>Hi,
>
>    I am trying to rename my outbound file from Training.txt  to
>Trainingxxxxxxxx where x's is MMDDYYYY. i am trying to do something like
>this:
>
>LET $SYSTEMDATE = EDIT(SUBSTR($sysdatetime,1,11),'MMDDYYYY')
>display $SYSTEMDATE                                 ! here i am able to get
>11172004
>
>let #ret_cd = rename($File2,$NEW_FILENAME)
>    if #ret_cd <> 0
>       show 'Error Renaming ' $File2 ' to ' $New_fileName ' Ret_cd = '
>#ret_cd
>   end-if
>
>where my $file2 is 'C:\Documents and Settings\lkra\Desktop\Training.txt'.
>
>I am getting the following error:-
>
>ERROR Renaming C:\Documents and Settings\lkra\Desktop\Training.txt to
>C:\Documents and Settings\lkra\Desktop\Training.txt11172004 Ret_cd =
>13.000000
>
>Thanks
>
>_________________________________________________________________
>Don't just search. Find. Check out the new MSN Search!
>http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.796 / Virus Database: 540 - Release Date: 11/13/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.796 / Virus Database: 540 - Release Date: 11/13/2004


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users