Am 18.05.2013 um 21:09 schrieb andy pugh <bodge...@gmail.com>: > On 18 May 2013 19:57, Chris Morley <chrisinnana...@hotmail.com> wrote: > >> In the Gcode you would ask for tool 1133 (tool 1 offset 33) but the toolfile >> must be able to hold >> the fact that there are two tool 1s. > > Yes. The primary key of "toolID" refers to a specific physical object. > > The likely keys in the table are > toolID comment T-number PocketNumber MagazineNumber SpindleNumber > Torus Frontangle BackAngle Orientation …. > > So, several ToolIDs would share the same T-number.
yes, I think tool groups require disassociating the gcode T-number from the pyhsical object id depending on the strategy you might have different queries to map T onto toolid: - always select the tool with the lowest wear - that'd be a a select all toolID for T, join with offsets(of type wear), order by offset, select toolid by lowest offset - select the tool which loads fastest (least hops in magazine): select all toolid for T, join with magazine positions, order by difference, select lowest probably the table above needs a column 'active' which starts out as true and can be set to false to disable a tool - either through breaking or if wear becomes too high; that would be an update run when wear offsets are updated active == true would become part of the select clause > I _think_ diameter is a geometry offset (diameter change is certainly > a wear offset) so doesn't live in the tool descriptor relation. > > -- > atp > If you can't fix it, you don't own it. > http://www.ifixit.com/Manifesto > > ------------------------------------------------------------------------------ > AlienVault Unified Security Management (USM) platform delivers complete > security visibility with the essential security capabilities. Easily and > efficiently configure, manage, and operate all of your security controls > from a single console and one unified framework. Download a free trial. > http://p.sf.net/sfu/alienvault_d2d > _______________________________________________ > Emc-developers mailing list > Emc-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/emc-developers ------------------------------------------------------------------------------ AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d _______________________________________________ Emc-developers mailing list Emc-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/emc-developers
