Re: SET DEFAULT or ?

2019-08-14 Thread Jean Laeremans
Must have done this at least 30 years ago. ;) Op wo 14 aug. 2019 13:27 schreef Alan Bourke : > You need to know the location of the data, say lcLocation then: > > If you're using a DBC it's just > open database (addbs(lcLocation) + "mydbc") > use table1 in 0 > use table2 in 0 > > If you're

Re: SET DEFAULT or ?

2019-08-14 Thread Alan Bourke
You need to know the location of the data, say lcLocation then: If you're using a DBC it's just open database (addbs(lcLocation) + "mydbc") use table1 in 0 use table2 in 0 If you're opening tables explicitly then then: use (addbs(lcLocation) + "table1") in 0 use (addbs(lcLocation) + "table2")

AW: SET DEFAULT or ?

2019-08-14 Thread juergen
Betreff: SET DEFAULT or ? Hello: I have an app that has for years been executed out of the default directory with the data there, too. Now, I have to give at least the data an arbitrary location. Can I use SET DEFAULT for this and save having to rewrite hundreds of table referring

Re: SET DEFAULT or ?

2019-08-14 Thread Peter Cushing
data an arbitrary > location. Can I use SET DEFAULT for this and save having to rewrite > hundreds of table referring statements? Or are there nasty things to > worry about? > > I am thinking of having a config table in the startup default > directory that specifies the

Re: SET DEFAULT or ?

2019-08-13 Thread Johan Nel
Gene, Again, I am not a VFP developer, but my understanding from the Clipper/VO/X# XBase fork: SET DEFAULT change the path where when not specifying a path, will determine where it will first look at trying to find the file.  The default is the Executing directory. SET PATH is used

SET DEFAULT or ?

2019-08-13 Thread Gene Wirchenko
Hello: I have an app that has for years been executed out of the default directory with the data there, too. Now, I have to give at least the data an arbitrary location. Can I use SET DEFAULT for this and save having to rewrite hundreds of table referring statements

Re: GETFILE and SET DEFAULT

2016-07-21 Thread Peter Cushing
and found that the value to be saved is returned by CURDIR() rather than SET('DEFAULT'). It gets restored with "SET DEFAULT TO." That explains why things weren't working for me! Somehow it seems better terminology could have been chosen! Thanks, Joe This communication is intended for

RE: GETFILE and SET DEFAULT

2016-07-21 Thread Dave Crozier
Set default to Won't work if the directory path name contains spaces so better to do: Set default to (saveDef) Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 20 July 2016 21:29 To: profox@leafe.com Subject: RE: GETFILE and SET

Re: GETFILE and SET DEFAULT

2016-07-20 Thread Koen Piller
uable.com>: > With Friends and Family like that, who needs a discount? ;-) > > -- > > rk > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted > Roche > Sent: Wednesday, July 20, 2016 4:58 PM > To: profoxt...@leafe.com > Subj

RE: GETFILE and SET DEFAULT

2016-07-20 Thread Richard Kaye
With Friends and Family like that, who needs a discount? ;-) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Wednesday, July 20, 2016 4:58 PM To: profoxt...@leafe.com Subject: Re: GETFILE and SET DEFAULT Well, he said I got

Re: GETFILE and SET DEFAULT

2016-07-20 Thread Ted Roche
oun...@leafe.com] On Behalf Of Ted Roche > Sent: Wednesday, July 20, 2016 4:53 PM > To: profoxt...@leafe.com > Subject: Re: GETFILE and SET DEFAULT > > I tell ya, the $59.95 I spent on HackFox7 was the best investment of > my Fox career! > > ;) > > On Wed, Jul 20, 2

RE: GETFILE and SET DEFAULT

2016-07-20 Thread Richard Kaye
Whil made you pay for your own copy? For shame... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Wednesday, July 20, 2016 4:53 PM To: profoxt...@leafe.com Subject: Re: GETFILE and SET DEFAULT I tell ya, the $59.95 I spent

Re: GETFILE and SET DEFAULT

2016-07-20 Thread Ted Roche
rofoxtech-boun...@leafe.com] On Behalf Of Richard > Kaye > Sent: Wednesday, July 20, 2016 4:46 PM > To: profoxt...@leafe.com > Subject: RE: GETFILE and SET DEFAULT > > If you really want to save off the fully qualified path, use a combination of > SYS(5) and SYS(2003). The first fu

Re: GETFILE and SET DEFAULT

2016-07-20 Thread Ted Roche
HackFox7 says: "For some reason, SET("DEFAULT") has never been enhanced to keep up with the times. It still returns just the drive with no path. No extra parameters or anything to let you find the path. Of course, CURDIR() provides the path. Even better, the undocumented SET(&qu

RE: GETFILE and SET DEFAULT

2016-07-20 Thread Richard Kaye
Or do what Ted says. :-) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, July 20, 2016 4:46 PM To: profoxt...@leafe.com Subject: RE: GETFILE and SET DEFAULT If you really want to save off the fully qualified path

RE: GETFILE and SET DEFAULT

2016-07-20 Thread Richard Kaye
) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder Sent: Wednesday, July 20, 2016 4:34 PM To: profoxt...@leafe.com Subject: Re: GETFILE and SET DEFAULT Actually I discovered that my code was disappearing after the commands were executed so I

Re: GETFILE and SET DEFAULT

2016-07-20 Thread Joe Yoder
Actually I discovered that my code was disappearing after the commands were executed so I did some more Googling and found that the value to be saved is returned by CURDIR() rather than SET('DEFAULT'). It gets restored with "SET DEFAULT TO." That explains why things weren't work

RE: GETFILE and SET DEFAULT

2016-07-20 Thread Richard Kaye
I've always fund that when macro expanding a memvar you don't want the m. so Set default to -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael copquin Sent: Wednesday, July 20, 2016 3:57 PM To: profoxt...@leafe.com Subject: Re: GETFILE

GETFILE and SET DEFAULT

2016-07-20 Thread Joe Yoder
on GETFILE and it appears that specifying the path to a specific folder is not a valid use. One needs to "SET DEFAULT TO" the desired path in a separate operation and then call GETFILE with the desired extension. This appears to work but when I tried to save and restore the setting

Re: GETFILE and SET DEFAULT

2016-07-20 Thread rafael copquin
Try this: m.SaveDef = set('DEFAULT') set default to ... do your thing then get back with set default to or set default to (m.SaveDef) Rafael Copquin On 20/07/2016 16:50, Joe Yoder wrote: I need to have a user choose a file with a specific extension from a specific folder. I