LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: PGeee

as the directory list has no LH pin, how do i stop it running until another node (Filter) has completed

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

You will need to use clocks. If your nodes have diagonal lines above the node icon with dots on the top, then clocks are visible. If not, to turn on clocks to go the bottom left corner of the application and double-click on the display mode icon that is selected. When the edit display window opens check the box next to "Clocks" and press ok.

Once clocks are visible on the nodes you can connect the filters RH clock pin to the LH clock pin of the directory list node. This will enforce a dependency even though there is no data dependency between the nodes.

To remove a clock, reconnect the 2 pins and when the pin turns red release the mouse button.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: PGeee

excellent, many thanks for that. In similar vein but with actual data being parsed, how do I get a database update to use a BRD file as input to SQL (It's for a backout option from a DB Store)

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You need to use the DbExecute node and the sqlNonSelect operator.

Look at the documentation for sqlNonSelect, but a simple example would be:



Query = "update mytable set name=:1 where id=:2"

sqlNonSelect(Query,'Name','Id')


One note: the parameter numbers above (:1 :2 :3 etc) MUST be in sequential order. It won't work if you try :1 :3 :2 or :1 :1 :2