dBASE Knowledge Base - Problems with paths in :duflp:creg0009.wfm

Author

Problems with paths in :duflp:creg0009.wfm

Ivar B. Jessen

2006-02-08, 7:23 am

Re duflp version dUFLPPLUS_O

The form :duflp:creg0009.wfm has the following problems with paths.

1) The path in line 75 is hard coded:

sql = 'select * from "..\Program
Files\dBASE\PLUS\Des
igner\Form\Creg0009.dbf"'

Previous versions of creg0009.wfm used the following sql:

sql = 'select * from " '+_dbwinhome+'Design
er\Form\Creg0009.dbf"'

2) Line 581: set procedure to creg2.wfm additive should be changed to:

set procedure to :duflp:creg2.wfm additive

Ivar B. Jessen

Ken Mayer [dBVIPS]

2006-02-08, 9:23 am

Ivar B. Jessen wrote:
> Re duflp version dUFLPPLUS_O
>
>
> The form :duflp:creg0009.wfm has the following problems with paths.
>
>
> 1) The path in line 75 is hard coded:
>
> sql = 'select * from "..\Program
> Files\dBASE\PLUS\Des
igner\Form\Creg0009.dbf"'
>
> Previous versions of creg0009.wfm used the following sql:
>
> sql = 'select * from " '+_dbwinhome+'Design
er\Form\Creg0009.dbf"'
>
>
> 2) Line 581: set procedure to creg2.wfm additive should be changed to:
>
> set procedure to :duflp:creg2.wfm additive

Thanks, I will look these over and get fixes in for the next release.

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Ivar B. Jessen

2006-02-08, 1:23 pm

On Wed, 08 Feb 2006 05:42:40 -0800, in dbase.knowledgebase,
Subject: Re: Problems with paths in :duflp:creg0009.wfm,
Message-ID: <hCSqJaLLGHA.1988@news-server>,
"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote:

>
>
>Thanks, I will look these over and get fixes in for the next release.

I just tried this:

modi form :duflp:creg0009.wfm

In the designer I moved the pushbutton a little and then saved the form. The sql
is now:

sql = 'select * from
"..\.. \Programmer\dBASE\PL
US221\Designer\Form\
Creg0009.dbf"'

It might be better to set the sql after the form is opened to prevent any
unintended change of the line.

Ivar B. Jessen

Ken Mayer [dBVIPS]

2006-02-09, 3:23 am

Ivar B. Jessen wrote:
> On Wed, 08 Feb 2006 05:42:40 -0800, in dbase.knowledgebase,
> Subject: Re: Problems with paths in :duflp:creg0009.wfm,
> Message-ID: <hCSqJaLLGHA.1988@news-server>,
> "Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote:
>
>
>
>
> I just tried this:
>
> modi form :duflp:creg0009.wfm
>
> In the designer I moved the pushbutton a little and then saved the form. The sql
> is now:
>
> sql = 'select * from
> "..\.. \Programmer\dBASE\PL
US221\Designer\Form\
Creg0009.dbf"'
>
> It might be better to set the sql after the form is opened to prevent any
> unintended change of the line.

Yeah. I have thought of that, and probably will. I've been busy with a
ton of other things (including trying to force myself back to working on
the next dBASE book) ... but that's probably the better solution ...

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Ken Mayer [dBVIPS]

2006-02-09, 9:23 am

Ken Mayer [dBVIPS] wrote:
> Ivar B. Jessen wrote:
>
>
>
> Yeah. I have thought of that, and probably will. I've been busy with a
> ton of other things (including trying to force myself back to working on
> the next dBASE book) ... but that's probably the better solution ...

Of course, the difficulty with this is that you have to set the
datalinks elsewhere ... the rowset doesn't exist until the query has
been activated ... bleh. But it's not a real complex form.

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Sponsored Links