Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
With Buffering = .T
Message
 
To
08/02/2020 09:19:45
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01665963
Message ID:
01672984
Views:
62
Hi,
I'm Francis, I fix vfp help file.

- the "WITH (BUFFERING = lExpr)" option is explained in the page :
HELP "SELECT - SQL Command - WITH Clause"
do you mean :

- Make update in help page named "SELECT - SQL Command - FROM Clause"
in part "Remarks" ?

actualy :
SELECT Select_List
   FROM Table_List 
...[WITH (BUFFERING = lExpr)]
   [WHERE Conditions]
   [GROUP BY Column_List]
   [UNION Clause]
   [HAVING Conditions]
   [ORDER BY Column_List]
   [INTO Clause | TO Clause ] 
   [Additional_Display_Options]
by
SELECT Select_List
   FROM Table_List [WITH (BUFFERING = lExpr)]
   [WHERE Conditions]
   [GROUP BY Column_List]
   [UNION Clause]
   [HAVING Conditions]
   [ORDER BY Column_List]
   [INTO Clause | TO Clause ] 
   [Additional_Display_Options]
Like print screen updated in attachment ?

about the header in the same page :

actualy
FROM [FORCE] Table_List_Item [, ...] 
      [[JoinType] JOIN DatabaseName!]Table [[AS] Local_Alias]
      [ON JoinCondition [AND | OR [JoinCondition | FilterCondition] ...]
can be corrected :
FROM [FORCE] Table_List_Item [, ...]  [WITH (BUFFERING = lExpr)]
      [[JoinType] JOIN DatabaseName!]Table [[AS] Local_Alias]  [WITH (BUFFERING = lExpr)]
      [ON JoinCondition [AND | OR [JoinCondition | FilterCondition] ...]
and others pages :
HELP "SELECT - SQL Command"
in part "Remarks"
and in header ?
HELP "SELECT - SQL Command - UNION Clause"
in part "Remarks"
HELP "SELECT - SQL Command - WHERE Clause"
in part "Remarks"
HELP "SELECT - SQL Command - WITH Clause"
in part "Remarks"
etc...
?

- thanks to Koen Piller to informed me of this discussion

- About VFPX - https://vfpx.github.io/projects/
The VFP Help File Project is here : https://github.com/VFPX/HelpFile

and you can open an issue about that in https://github.com/VFPX/HelpFile/issues
Please : with the exact title of the page + the existing text + the text corrected proposal.
Thanks

regards
Francis

>The way the Help is written, I'd not coded this way on first try...
>So "with Buffering" is actually a sub-clause of from and syntactic sugar nephew Join,
>not a clause of the select. Writing "With" in its own line, linking and citing from "select" but not from "From" would have led me astray.
>SELECT Select_List
>   FROM Table_List
>...[WITH (BUFFERING = lExpr)]
>   [WHERE Conditions]
>   [GROUP BY Column_List]
>   [UNION Clause]
>   [HAVING Conditions]
>   [ORDER BY Column_List]
>   [INTO Clause | TO Clause ] 
>   [Additional_Display_Options]
>as "..." (if seen at all) would have not registered on first readings, esp, as not mentioned / linked to from "From" Clause. Might be an idea to forward "With is a clause to from/join, not select" to the person(s) having made the effort to fix vfp help on vfpX.

Exactly. The syntactically correct form of this meta-syntax description would be to put the With clause into each entry of the table_list.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform