News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

ShapeSheet Events

Started by drewdb, August 18, 2008, 02:53:08 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

drewdb

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

Does anyone know if this is at least possible or not so that i can move into another direction?

Thanks again.

vojo

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

Thanks for that, i will give this a try tomorrow. it makes sense.

drewdb

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.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 200 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1053KB.
Tokens: post-login.
Cache hits: 13: 0.00166s for 26,733 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]