two questions 1

[michaelkrauklis]

First, while using a form created by ObjectPAL in Paradox 8, I attempt to change the working directory:
setWorkingDir( string String )
Now CP8 tries to close all windows when the working directory is changed, thus doing one of two things:
1)closing my form before the working dir is changed
2)running my form w/ the old working dir, then changing it
I tried to catch the MenuEvent so that it wouldn't close my form window, but to no avail. Any suggestions?

Second, I'm trying to do a simple export of a bunch of tables to text. My main problem is the fact that some of the tables contain Memo fields. Now I've gotten it to output all the fields correctly but some of the memo fields contain newline characters, which messes up all the delimiting. Is there a simple way to get those newline characters out of there before I send it to text? If not I'm sure I can write another program in c or java to do it, but it would be nice if I could ommit that step. I'm very new to paradox, just using it temporarily at work. Thanks! MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com

 

[michaelkrauklis]

Well I may have answered my own question here. The first one at least. Just throw in an rTrim() and that should remove any newlines and/or white space. We'll see if that works or not... MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com

 

[michaelkrauklis]

Crap, no dice. I'm using TextStream:writeString(rTrim(var))
yet I'm still getting a CR/LF at the end. I'm stuck. Any ideas? MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com

 

[footpad]

1) You need to block the default behavior of the menuChangingWork menuAction on every form that needs to remain open.

For more details, please see

http://techtricks.com/paradox/keepopen.php3.

2) Possible? Yes. Simple? Depends. Check out

http://techtricks.com/paradox/exportmemo.php3

and see what you think.

Hope this helps...

-- Lance

 

[michaelkrauklis]

Thanks for the help. I already figured out the second question. I just needed to sleep on it. My problem was that I was only parsing memo fields that were larger than the allowable string size. I simply changed my logic to parse all memo fields and things are golden I think. It a slow slow process(been running for about 20 minutes and doesn't show any signs of stopping), but hopefully it will be better than the process my company currently uses, which takes a little over 48 hours. Thanks again for the links. MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com

 

[michaelkrauklis]

I think I figured out the first problem too. I was only putting the MenuEvent handling code in the menuAction method of the button I push to change the working dir. That site ironed out everything. thanks MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com