Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving SQL Server messages through ODBC
Message
 
 
À
24/04/2008 03:57:32
Issam Mansour
Jordan Business Machines
Amman, Jordanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01312818
Message ID:
01312856
Vues:
16
It cannot be done with SqlExec. It should be possible with ODBC API. Re: ODBCs SQLRowCount() - How to use? Thread #810276 Message #811151 may give you some directions.
You can also explore SQL-DMO server object ExecuteWithResultsAndMessages2 method.

>I'm having problem retrieving SQL Server PRINT and other messages to my front-end Visual FoxPro application.
>For example, SQL commands like BACKUP DATABASE running in the back-end produce a progress statistic by printing the percent completed, however, that doesn't come in the form of a result set, but as a printed message.
>(in my case, I'm trying to have a progress bar indicating the backup progress in the front-end GUI).
>
>In the VFP help I only found one way and that is via the AERROR() function, however, that one would return only the error messages and not the non-error messages.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform