Show/Hide Toolbars

ASPRunnerPro 9.8 Manual

Navigation: Advanced topics > Events > Table events > Add page

ASPrunnerPro32x32     ASPRunnerPro manual


Event: BeforeAdd

Scroll Prev Next More

 

Description

Function BeforeAdd is executed before a record is physically added to the database. Will work in all add modes: Inline Add, Regular Add and Add page in popup.

Syntax

BeforeAdd(values,message,inline,pageObject)

Arguments

values - array of values to be written to the database. To access specific field value use values("FieldName").

Field names are case-sensitive. If the field name is PlayerId, you should use values("PlayerId"). Note that values("playerid") or values("PlayerID") will not work.

If the field was assigned an alias in the SQL query, then the values array will get the alias instead of field name from the database. E.g. if you have SQL query select salesrep_id AS Inv_Salesrep ..., you should use values("Inv_Salesrep").

message - place the message to be displayed into this variable.

inline - equals to '1' when the Inline Edit in process, '0' - otherwise.

pageObject - an object representing the current page. For more information, see RunnerPage class.

Return value

True: continue with adding a record.

False: record would not be added.

Applies to pages

Add, Inline Add

Recommended sample events

Add custom field to form

Limit number of records users can add

Select multiple values from checkboxes or a list field and have them appear as individual database entries

Update multiple tables

Send mass email to al users

Rename uploaded files

Speed up data entry using events