Client applications can now be programmatically identified using Advantage's new application identification feature. By default, application identification resolves to the name of the executable that is connected to Advantage. If you want, you can also programmatically set the application identification for a particular client application through the sp_SetApplicationID system stored procedure.
There are two ways to read the application ID. You can use the Advantage SQL scalar function APPLICATIONID, or the sp_GetApplicationID system stored procedure. These functions are particularly useful from within triggers and stored procedures, permitting you to note which of your client applications is causing the routine to execute.