Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to change Application.name
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Installation et configuration
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01048058
Message ID:
01048069
Vues:
20
In the ODBC connectionn string set
APP=UserName;
>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?
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform