Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldBox » Edit Q-File Expression
Post new topic  Reply to topic View previous topic :: View next topic 
Edit Q-File Expression
PostPosted: Thu Feb 03, 2011 11:23 am Points: 0 Reply with quote
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?
View user's profile Send private message

PostPosted: Thu Feb 03, 2011 11:59 am Points: 0 Reply with quote
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.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Thu Feb 03, 2011 12:33 pm Points: 0 Reply with quote
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.
View user's profile Send private message

PostPosted: Thu Feb 03, 2011 12:57 pm Points: 0 Reply with quote
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.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Thu Feb 03, 2011 8:41 pm Points: 0 Reply with quote
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.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Fri Feb 04, 2011 6:53 am Points: 0 Reply with quote
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.
View user's profile Send private message

PostPosted: Mon Feb 07, 2011 11:15 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




You're quite welcome.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

Edit Q-File Expression
  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  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin