Reporting Utility

ACAD_db command line echoes and Error Reports

1. File is opened read only mode:

   Command line echo:

   Document is read only

   All ACAD_db commands and events are disabled on read only files.

2. File is opened which is not ACAD_db compatible [Not listed in table JTBW_Files]

   Command line echo:

   This document is not compatible with database.

   Use command "AcDbMake" to make this document compatible.

   Attribute to database sync utility is disabled for this document.

3. Use command "AcDbMake" converts this file to ACAD_db compatible.

   Command line echo:

   5 number of block with attributes edited in this session.

   "Data Source Location" = C:\path\Data Links

   This file is now compatible with database.

   Attribute to database sync utility is enabled for this document.

4. File is opened which is ACAD_db compatible [listed in table JTBW_Files] and no block definitions are available.

   Command line echo:

   No block definition with attribute is available to sync.

5. File is opened and no block references used in the drawing.

   Command line echo:

   BLOCKNAME1 Reference count 0

   BLOCKNAME2 Reference count 0

   No block definition with attribute is available to sync.

6. When "AcDbInsert" command used and has no new block records in the table. [No empty handle number in the field "Handle" of table for this file].

   Command line echo:

   BLOCKNAME1 : No missing blocks in database

7. When "AcDbInsert" command used and has no local block definition and block file name is mentioned incorrectly in the table.

   Command line echo:

   BLOCKNAME1: Block insertion failed.

   Missing file error: BLOCKNAME1

   Specify full file name in the table "JTBW_BlockLayer", for example : "F:\folder location\library.dwg"

8. When "AcDbInsert" command used and has no local block definition. [Copies definition from external file as specified in table]

   Command line echo:

   BLOCKNAME1: block definition added from file = F:\blocks.dwg

   Block name: BLOCKNAME1, Handle = B45 "Inserted New Reference"

9. When blocks are erased and saved.

   Command line echo:

   Erased block reference BLOCKNAME1 with handle number "A24", "unmarked -1" in database.

10. When block reference inserted into drawing manually.

    Command line echo:

    Totally number of block attribute edited in this session = 1

11. When block reference copied in the drawing.

    Command line echo:

    Total number of block attribute edited in this session = 2

12. When drawing is saved and there are edited block references or new block references inserted.

    Command line echo:

    Attribute to database Sync Started….

    Database = f:\mydatabase.mdb :

    Block Name = BLOCKNAME1 ; Handle = BEB

    …

13. Error : Syntax error in UPDATE statement

    The reason for this can be that a database field is a reserved SQL word

    Examples: http://msdn.microsoft.com/en-us/library/aa238507(v=sql.80).aspx

Error dialog box messages

1. When "JTBW_AttSync" table is missing table.



2. When one of the required columns is missing in "JTBW_AttSync" table.



3. When "JTBW_Files" table is missing.



4. When required column DWGNAME is missing in "JTBW_ Files" table.



5. When required column DWGNAME is missing in "JTBW_ BlockLayer" table.



6. When required column(s) missing in "JTBW_ BlockLayer" table.




In case of SQL server:




7. When required table used to store attribute value is missing in the database.

Contact and Support