Expert Mode

In the procedure search area you can write SQL expressions to search for the use of cover tools (procedures, actions, tables, labour,...)

Example:

• I want to know all the procedures that call the ID=940 procedure (#940)
  • @id in (select owner FROM procedureNodes where [type]=5 and ref=940)
    • [type]= constant of the type of element whose use we wish to know (see tab under)
    • ref= ID of the element whose use we wish to know

• I want to retrieve all procedures using a stack command that STARTS with PUSH V

  • @id in (select procedureNodes.owner from procedureNodes, procedureCommandLine where (procedureNodes.type=6) and (procedureNodes.ref = procedureCommandLine.id) AND (commandLine LIKE "PUSH V%"))

• which contains PUSH V 0

  • @id in (select procedureNodes.owner from procedureNodes, procedureCommandLine where (procedureNodes.type=6) and (procedureNodes.ref = procedureCommandLine.id) AND (commandLine LIKE "PUSH V 0"))

• I want to find out where a variable tree is located -@variabletree=id of the tree

  • open the windows where you can edit a variable tree
    • construction model
    • nodes
    • beams

• Table of constants

Item	Type (Constant)	expression
itCondition	0	@id in (select owner FROM procedureNodes where [type]=0 and ref=ID)
itElse	1	@id in (select owner FROM procedureNodes where [type]=1 and ref=ID)
itMessage	2	@id in (select owner FROM procedureNodes where [type]=2 and ref=ID)
itAction	3	@id in (select owner FROM procedureNodes where [type]=3 and ref=ID)
itProcedure	5	@id in (select owner FROM procedureNodes where [type]=5 and ref=ID)
itCommandLine	6	@id in (select owner FROM procedureNodes where [type]=6 and ref=ID)
itForLoop	7	@id in (select owner FROM procedureNodes where [type]=7 and ref=ID)
itComment	9	@id in (select owner FROM procedureNodes where [type]=9 and ref=ID)
itArray	10	@id in (select owner FROM procedureNodes where [type]=10 and ref=ID)
itArticle	11	@id in (select owner FROM procedureNodes where [type]=11 and ref=ID)
itLabour	12	@id in (select owner FROM procedureNodes where [type]=12 and ref=ID)

---