Re: Non-SQR question

[Cherno Jagne <ITSCJ@QE2-HSC.NS.CA>]

Rick,

You can try using OLE if you have the scripting object model. I am
not very certain if it comes with Win95/98/NT or if you have
to manually set it up (the scripting object model, that is). I can try
and find out.

Anyway, you can try this piece of PeopleCode and see if it works--
it did for me:

Local object &FS;
Local object &F;

   &FS = CreateObject("Scripting.FileSystemObject");
   &F = ObjectDoMethod(&FS, "CreateTextFile", "c:\temp\oletest.txt",
"True");
   ObjectDoMethod(&F, "WriteLine", "This is the first line.");
   ObjectDoMethod(&F, "WriteLine", "This is the second line.");
   ObjectDoMethod(&F, "WriteLine", "Bye, bye...");
   ObjectDoMethod(&F, "Close");
   WinMessage("Done!");

If the above works, you can find details in the PeopleBooks PeopleCode
reference, under OLE functions, and the online MSDN library for the
FileSystemObject (do a search at msdn.microsoft.com).

When it works, it does so like a charm and is much cleaner than
setting up SQR's and all that stuff. I'd say it's worth the trouble
following
up on the leads above.

Cherno.

>>> <Rick_Creel@AONCONS.COM> 06/28 10:50 AM >>>
This question doesn't involve SQR, and for that I apologize.  I know
there are a
number of PeopleSoft users in this SQR group, so I am appealing to them
for an
answer.  My question is...   Is there a way within PeopleCode (that is
attached
to a record)  to have a "flat file" record written to the local hard
drive?

I know I can do this by having a process definition kick-off an SQR run,
but I
was hoping to avoid having to set all that crap up.
Any help would be greatly appreciated !

TIA