Try aerror() function just after executing any command for SQL Server from VFP. Probably (I'm not sure) you will get all warning messages there, even when no error generated by VFP.
>I have a few (SQL server) stored procedures that are triggering some system warnings as well as some of my own warnings (serverity 10). I'd like to return those warnings to the client (VFP through ODBC). There is the "Dispwarning" setting that I set to TRUE, but it looks like the SQL will report the warnings only if at lest one error (severity 16 ot higher) occurred.
>
>Is there any way I can return the all warnings even if no error occured?
>
>Thank you.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
