How to search on the Specification field

So we all know that the all specification and notation fields are kept in a binary format in VISUAL. This is a problem if you’re wanting to search in these fields.  Here’s what you can do to overcome this obstacle.

I’ll walk you through setting this up in PART MAINTENANCE – and then you can implement this throughout the remaining modules in VISUAL.

  1. Create a view (using the statement below) that will link the PART table to the PART_BINARY table.  This view will also convert the BITS field to a string value.———————-
    CREATE VIEW [dbo].[PART_VIEW] AS
    SELECT P.*,
    CAST(CAST(PB.BITS AS VARBINARY(MAX)) AS VARCHAR(MAX)) AS BITS,
    PB.BITS_LENGTH
    FROM PART P
    LEFT JOIN PART_BINARY PB ON P.ID = PB.PART_ID AND PB.TYPE = ‘D’
    ———————-
  2. Next we need to modify the VMBROWSE.ini file to configure the PART browse function to use this new view for searching.  This file can be found in your VISUAL local directory.  In the VMBROSE.ini file, locate the [PART] section and change the ‘table’ from PART to PART_VIEW…..
    [Part]
    table=PART_VIEW
    ….
  3. To complete this process, go to PART MAINTENANCE and browse for parts.  From the Browse window, select Edit Columns under the DATA menu.  Within the list of available fields you should be able to pick the BITS field to search on.

    How to search on the Specification field


Thanks to Dave Giusto for helping me “fine-tune” this great tip. Dave currently works out of the New York office of Synergy Resources and can be reached there or via the Visual Manufacturing International User Group (VMIUG) under the handle dave_giusto.

Copyright 2019 visualnuggets © All Rights Reserved