Hello,
Situation:
Front-end: VFP 8.0 SP1
Back-end: MS SQL Server 2000
Connection via ODBC with SQL Server authentication.
Problem:
When user makes changes on data, I want that trigger which fires could get UserName which User logged into workstation.
I found one solution: to change Application name, then SQL server can get user id via SQL function app_name().
The problem is that Application.Name is read-only in VFP and allways contains "Microsoft Visual Foxpro".
How to change Application.Name value? Is it possible?
Thanks in advance,
Giedrius