Member Avatar for Cal_GIS

I need some help. Some collegues need to link their AutoCAD files with an external data base, in this case in Oracle. So far pretty simple, and done...

Next step is to link functionality, if a record is deleted in the db, we want the corresponding CAD drawing component deleted also. For instance, if a building has a fire exit filled in, then we want to be able to delete it in the database, and the corresponding diagram disapears in the CAD dwg, and vise versa.

Any help would be greatly appreciated. Has anyone done this? Have you come across some coding in open source etc.

  • 2 Contributors
  • 4 Replies
  • 128 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by Cal_GIS
Member Avatar for debasisdas

Is you application connected to oracle database ?

Member Avatar for Cal_GIS

Is you application connected to oracle database ?

Yes, the AutoCAD items are linked with the items in the Oracle Database, however if one is deleted, it has no effect on the other. That is where our problem is.

Any solutions??

Member Avatar for debasisdas

Are you commiting after each Delete operation in the code ?

Member Avatar for Cal_GIS

Sorry, I am not sure what you mean there. Pelase expalin what you mean.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.