This topic is locked

How to prevent a field from being written to the database.

12/13/2015 9:55:53 AM
ASPRunnerPro General questions
L
LGessert author

On the Add/Edit page, I want to prevent a field from being written to the database in the Before Record Added event. In searching the forums I see numerous references to "unset" which I do not believe is an option in ASPRunnerPro 6.3. Any suggestions on how to accomplish this?
Background: I need a dropdown list of courses that is dependent (or filtered) on the course type. I set up a dependent dropdown in the lookup wizard to do this and therefore needed to include the course type as a field in this table of selected courses. But I do not want to save the course type in the table to which I am adding the selected courses. A separate course table manages the course ID, course name and course type fields. Knowing the ID of the course, I can find the course type in the related course table. If I record course type in the table of selected courses and the course type changes in the course table there's a problem.
This is no different than the Make/Model examples in the help guides, but I can't help but think "why record the model"? The model is implied from the make in a relational database.

G
gonzalosb 1/1/2016

you can try this:
http://xlinesoft.com/asprunnernet/docs/deletefield.htm
Aldo why you want to add a drop drown selection if you not going to save it? will get problems when you go to edit the info.

admin 1/2/2016

You should always refer to your manual first. Click 'Help' button anywhere in ASPRunnerPro to access the manual.
Here is the relevant article:

http://xlinesoft.com/asprunnerpro/docs63/update_multiple_tables.htm