| Edit Q-File Expression | |
Posted: Thu Feb 03, 2011 11:23 am |
Points: 0 |
|
tt |
GoldMine Apprentice |
|
|
Joined: 18 Jan 2007 |
Posts: 23 |
|
|
|
|
|
|
|
|
I'm sure this is a silly question but here it goes.
I have a Q-File that renames a file with the Rename-File function. I am trying to change the file path that is already entered to a new one. I can see that I can manually change the value directly in the Q-File setup screen. But is there any way that I can bring up the "Key In An Expression" screen to edit the field? |
|
|
|
|
Posted: Thu Feb 03, 2011 11:59 am |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
Not quite sure what you mean. Are you saying that you want to bring it up so you can interactively specify the new filename, while the Q-file is running? What version of GoldBox? |
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
Posted: Thu Feb 03, 2011 12:33 pm |
Points: 0 |
|
tt |
GoldMine Apprentice |
|
|
Joined: 18 Jan 2007 |
Posts: 23 |
|
|
|
|
|
|
|
|
Sorry if I wasn't clear. What I am trying to do is as follows:
Go to Automate | Q-File Setup then open an existing Q-file. Within that Q-File there is a step to Rename-File. I want to edit the existing file path and change it to a different path. But I want to do this by browsing to the file location and not by directly (manually) typing the path in.
I've tried highlight the existing path and then used the "Key An Expression" in the upper right of the screen. That does bring me to the "expression builder" screen where I can browse to the new file path, but then the expression gets entered as the 5th parameter and it does not replace the parameter I had highlighted..
I'm using GX-7. |
|
|
|
|
| | |
Posted: Thu Feb 03, 2011 12:57 pm |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
Well, what I see is two windows. The first one (which you seem to he discussing) is for the already-existing file, the one you want to RENAME. You just hit the elipse (...) button and navigate to that file. You seem to be making more of it than there is.
If you really mean the second window, which is for the NEWLY RENAMED filename (and path, if changed), then that's another matter. I'll be happy to discuss your options there, if you'll confirm that's what you really mean. |
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
Posted: Thu Feb 03, 2011 8:41 pm |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
i have to go out of town Friday, so let me try to clear this up now.
I think you are talking about the second window, and that you are talking about editing that value after it's been entered, at which time it's under the 4th Parameter column. You are right, if you click on the green arrow next to "Key in an Expression", the resulting value will be entered into the 5th Parameter colum, which is not what you want.
I'd just use "Key In an Expression" to select the path you want; let GoldBox enter it into Parm 5; then copy/paste that value, and use it to overwrite what's currently in 4th Param. Then just clear the Param 5 column. But don't forget to insert the final backslash and the filename in the Param 4 column. Yes, it's a bit kludgy, but it works.
Of course, if you want your filename to be calculated (which I usually do), you'd add that after the path, like so:
Code: |
"c:\gmapps\gx7\ahisteml\D"+DtoS(Date())+"_"+StrTran(Time(), ":", "")+".dbf" |
which just evaluated to c:\gmapps\gx7\ahisteml\D20110204_070740.dbf but which changes constantly, so it's always unique. |
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
Posted: Fri Feb 04, 2011 6:53 am |
Points: 0 |
|
tt |
GoldMine Apprentice |
|
|
Joined: 18 Jan 2007 |
Posts: 23 |
|
|
|
|
|
|
|
|
Hi Bob,
You are right, I was asking about the 2nd window and your answer cleard up what I was trying to find out. I basically assumed that I was missing something obvious that would allow me to edit the 4th parameter directly. Part of Goldbox's "charms" are it's little quirks and I thought I had over looked one that would allow me to directly edit the current entry.
Thanks for confirming I hadn't overlooked something and offering a work around. |
|
|
|
|
Posted: Mon Feb 07, 2011 11:15 am |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
ContactReview Forum Index » GoldBox
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|