VS:AddWSColumnOperator: Difference between revisions

Latest revision as of 08:37, 24 June 2022

.VectorScript|VectorScript ..VS:Function Reference|Function Reference ..VS:Function_Reference_Appendix|Appendix

Description

Adds database column operator to specified column.

PROCEDURE AddWSColumnOperator(
                worksheet      :HANDLE;
                databaseRow    :INTEGER;
                column         :INTEGER;
                operatorType   :INTEGER);

def vs.AddWSColumnOperator(worksheet, databaseRow, column, operatorType):
    return None

Parameters

worksheet	HANDLE	Handle to worksheet.
databaseRow	INTEGER	Database row to be queried.
column	INTEGER	Column to be queried.
operatorType	INTEGER	Operator type.

Remarks

Operator type constants:

All operators = -1
Sort operator = 0
Summarize operator = 1
Add operator = 2

Version

Availability: from Vectorworks 2012

@@ Line 50: / Line 50: @@
 All operators = -1<BR>
 Sort operator = 0<BR>
-Summarise operator = 1
+Summarize operator = 1<BR>
+Add operator = 2</remark>
-(2018-12-30 - Peter Vandewalle): To add a sum operator, first add all operators and then remove the sort operator and the summarise operator:
-==== Vectorscript ====
-<code lang="pas">
-AddWSColumnOperator(hWS, 1, 1, -1);
-RemoveWSColumnOperator(hWS, 1, 1, 0);
-RemoveWSColumnOperator(hWS, 1, 1, 1);
-</code>
-==== Python ====
-<code lang="py">
-vs.AddWSColumnOperator(hWS, 1, 1, -1)
-vs.RemoveWSColumnOperator(hWS, 1, 1, 0)
-vs.RemoveWSColumnOperator(hWS, 1, 1, 1)
-</code>
-</remark>
 -----------------------------------------------------------------------------------------------------------
@@ Line 71: / Line 57: @@
 -----------------------------------------------------------------------------------------------------------
-<seeAlso>
+<seeAlso></seeAlso>
-VS Functions:
-* [[VS:RemoveWSColumnOperator| RemoveWSColumnOperator]]
-</seeAlso>
 -----------------------------------------------------------------------------------------------------------