Author Topic: ShapeSheet Events  (Read 8565 times)

0 Members and 1 Guest are viewing this topic.

drewdb

  • Jr. Member
  • **
  • Posts: 30
ShapeSheet Events
« on: August 17, 2008, 09:53:08 PM »
Hope i'm not asking too many question?

Is it possible to do the following?

I have a shape that i fill some of the shape data from an access database.
I have an action RUNADDON(DBU) that the user can right click and update the record in the database.
I have an action RUNADDON(NETWORK SHAPE PROPERTIES) to show the shape data and allow for editing.

Is it possible to add it to an event that will update the record when the user modifies is on the shape data properties section?

I've tried the "TheData" and "TheText" from the events section with no luck.

drewdb

  • Jr. Member
  • **
  • Posts: 30
Re: ShapeSheet Events
« Reply #1 on: August 19, 2008, 06:14:06 PM »
Does anyone know if this is at least possible or not so that i can move into another direction?

Thanks again.

vojo

  • Hero Member
  • *****
  • Posts: 1708
Re: ShapeSheet Events
« Reply #2 on: August 19, 2008, 09:34:34 PM »
Might try using the dependson function in the cell that does the update....something like this

prop.mycustompropertie = "hi bud"
user.my_cell_to_update_db = runaddonwarg(dbu)+dependson(prop.mycustompropertie)

This way, every time the prop cell changes via human typing in something else, the update cell is triggered.   I believe this will cause the runaddonwarg to fire...from there you know the drill.

drewdb

  • Jr. Member
  • **
  • Posts: 30
Re: ShapeSheet Events
« Reply #3 on: August 20, 2008, 03:42:27 AM »
Thanks for that, i will give this a try tomorrow. it makes sense.

drewdb

  • Jr. Member
  • **
  • Posts: 30
Re: ShapeSheet Events
« Reply #4 on: August 20, 2008, 11:36:31 PM »
Thanks for that. it works well. I couldn't get it to accept it at first but i found that
=RUNADDON("DBU")+DEPENDSON(Prop.CostPrice) worked.

Thanks again. Saves the users one more step.