Querying Access for Visio's Use
Listing 22.4 shows a deletion process when items are deleted in Visio and they need to have the corresponding record deleted in the Access database.
Listing 22.4. Deleting Database Records by Deleting Shapes in a Visio Diagram
Public g_dbsMyDatabase As DAO.Database Public g_szDBFileName As String Public g_bTrack As Boolean Global Const g_szDefFileName$ = "d:\MyDatabase.mdb" Global Const g_nFileNotFound% = &HFFFFFFFF Global Const g_szTableName$ = "Item" Global Const g_szFieldCost$ = "ItemCost" Global Const g_szFieldName$ = "ItemName" Global Const g_szFieldGUID$ = "ItemID" Global Const g_szUserFileName$ = "User.DBFileName" Global Const g_szUserTrack$ = "User.Track" Global Const g_szPropTrack$ = "Prop.Track" Global ... |
Get Professional Development with Visio® 2000 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
