A Helpful Hint (In case you didnt know)

Scriptcase 9 General
#1

In case anyone ever needs the need to be able to change the default application in a menu application dynamically.

You can use a variable in the application field instead of having to select one.

I needed it to be able to have a certain calendar come up based on the users role.

i.e.

/**
 * Determine app to show based on role
 */

// Check for record
$check_sql = "SELECT login"
   . " FROM program_sec_users_groups"
   . " WHERE login = '" . [usr_login] . "'"
   . " and group_id = '2'";

sc_lookup(rs, $check_sql);

if (isset({rs[0][0]}))     // Row found
{
    $security_menu = 'Gen_Cal_Data';
   
}
else     // No row found
{
    $security_menu = 'Gen_Cal_Data_LOA';
	
   
}

The More You Know…

Kev