Re: Performance with qualifier/scope (was RE: GETFILE() Returns Empty String in Some Cases)

2017-08-05 Thread Laurie Alvey
A few thoughts:
STORE can only refer to variables.
FOR...ENDFOR loops only use variables..
The assignment x = y implies that x must be a variable (you cannot assign
to a field using that  syntax).
The assignment x = m.y would remove any ambiguity.

There are a load more examples on the FoxWiki
http://fox.wikis.com/wc.dll?Wiki~EssentialMDot~Wiki.

Laurie

On 4 August 2017 at 22:02, Alan Bourke  wrote:

> More typing, never seen the point.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
> On Fri, 4 Aug 2017, at 10:49 AM,
> mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
> > On 2017-08-03 18:23, Darren wrote:
> > > Personally I use this approach ...
> > >
> > > STORE m.variable|obj.property|table.fieldname to variable.   Fully
> > > qualify
> > > everything / always. Easier to debug as well.
> > >
> > > Additional to results below ... STORE/ = | with/without m. |  with/
> > > without
> > > table open.
> > >
> > > No Table Open   x=y 0.1320
> > > No Table Open   STORE y to x0.0870
> > > No Table Open   x=m.y   0.1328
> > > No Table Open   STORE m.y to x  0.0879
> > > Table Open  x=y 0.2081
> > > Table Open  STORE y to x0.1644
> > > Table Open  x=m.y   0.1326
> > > Table Open  STORE m.y to x  0.0879
> > >
> > > No Table Open   STORE y to x0.0870
> > > No Table Open   STORE m.y to x  0.0879
> > > Table Open  STORE m.y to x  0.0879
> > > No Table Open   x=y 0.1320
> > > Table Open  x=m.y   0.1326
> > > No Table Open   x=m.y   0.1328
> > > Table Open  STORE y to x0.1644
> > > Table Open  x=y 0.2081
> >
> >
> > Can't argue with the numbers, but personally I've never liked STORE.  No
> > good reason I guess except it never felt normal (but hey, that's
> > ok...use the Fox at its best, however that is!).
> >
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAMvTR9d3F9m__j-jB_cQzRah805OuasniaUms-XH-51Je8=w...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Performance with qualifier/scope (was RE: GETFILE() Returns Empty String in Some Cases)

2017-08-04 Thread Alan Bourke
More typing, never seen the point.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

On Fri, 4 Aug 2017, at 10:49 AM,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
> On 2017-08-03 18:23, Darren wrote:
> > Personally I use this approach ...
> > 
> > STORE m.variable|obj.property|table.fieldname to variable.   Fully 
> > qualify
> > everything / always. Easier to debug as well.
> > 
> > Additional to results below ... STORE/ = | with/without m. |  with/ 
> > without
> > table open.
> > 
> > No Table Open   x=y 0.1320
> > No Table Open   STORE y to x0.0870
> > No Table Open   x=m.y   0.1328
> > No Table Open   STORE m.y to x  0.0879
> > Table Open  x=y 0.2081
> > Table Open  STORE y to x0.1644
> > Table Open  x=m.y   0.1326
> > Table Open  STORE m.y to x  0.0879
> > 
> > No Table Open   STORE y to x0.0870
> > No Table Open   STORE m.y to x  0.0879
> > Table Open  STORE m.y to x  0.0879
> > No Table Open   x=y 0.1320
> > Table Open  x=m.y   0.1326
> > No Table Open   x=m.y   0.1328
> > Table Open  STORE y to x0.1644
> > Table Open  x=y 0.2081
> 
> 
> Can't argue with the numbers, but personally I've never liked STORE.  No 
> good reason I guess except it never felt normal (but hey, that's 
> ok...use the Fox at its best, however that is!).
> 
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1501880557.3304411.1063593704.604bc...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Performance with qualifier/scope (was RE: GETFILE() Returns Empty String in Some Cases)

2017-08-04 Thread mbsoftwaresolutions

On 2017-08-03 18:23, Darren wrote:

Personally I use this approach ...

STORE m.variable|obj.property|table.fieldname to variable.   Fully 
qualify

everything / always. Easier to debug as well.

Additional to results below ... STORE/ = | with/without m. |  with/ 
without

table open.

No Table Open   x=y 0.1320
No Table Open   STORE y to x0.0870
No Table Open   x=m.y   0.1328
No Table Open   STORE m.y to x  0.0879
Table Open  x=y 0.2081
Table Open  STORE y to x0.1644
Table Open  x=m.y   0.1326
Table Open  STORE m.y to x  0.0879

No Table Open   STORE y to x0.0870
No Table Open   STORE m.y to x  0.0879
Table Open  STORE m.y to x  0.0879
No Table Open   x=y 0.1320
Table Open  x=m.y   0.1326
No Table Open   x=m.y   0.1328
Table Open  STORE y to x0.1644
Table Open  x=y 0.2081



Can't argue with the numbers, but personally I've never liked STORE.  No 
good reason I guess except it never felt normal (but hey, that's 
ok...use the Fox at its best, however that is!).



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/153adb6149f9e8fdaf249d24a5667...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.