Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving SQL Server messages through ODBC
Message
From
24/04/2008 03:57:32
Issam Mansour
Jordan Business Machines
Amman, Jordan
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Retrieving SQL Server messages through ODBC
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01312818
Message ID:
01312818
Views:
77
Hi,
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.
Any suggestions?

Thanks,
T.
Next
Reply
Map
View

Click here to load this message in the networking platform