Nate Holt's Blog

February 11, 2015

How Wire Sequencing data is held in WDATA table

Filed under: Electrical — nateholt @ 1:52 am

This is the second of the series on the WDATA table format and will be of interest to one or two folks, if that (link here). But the question came up recently, so here goes…

Let’s look at an example of BEFORE and then AFTER.

Here is the wire network we’ll look at for this example. It’s the hot wire 224 below that interconnects six devices. Normal from/to reporting will likely list them top to bottom, left to right.




Here is what the above network’s record looks like in this project’s database file, WDATA table, for wire 224 BEFORE it is sequenced (Project Database file is opened and viewed with a copy of Microsoft Access). It’s pretty cryptic. It has six groupings of data, one for each wire connection in wire the wire number 224 network. Note that each wire connection entry in this list carries a value of “900” in its 22nd position. This “900” value is the default AcadE uses to signify a “non-sequenced” connection.


Now we run the Sequence Wire command and force some defined wire sequence. What we now have for from/to connection sequence is illustrated below with the “Show Sequence” command.




Here is what the WDATA table’s record now looks like for wire network 224. The “900” un-sequenced flag is now replaced with an incrementing 3-digit number starting at “001”.


To see it more cleanly, here are the subentries pulled out and shown separately. Sorting on the 22nd entry yields this wire connection sequence. Note that it matches the results shown in the “Show Sequence” tool above! The From/To reporting for wire number “224” will now show this connection sequence.





Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: