XPost: microsoft.public.sqlserver.programming   
      
   >On 18-03-2011 23:46, Gene Wirchenko wrote:   
   > I can catch the very basic errors, but not detailed error codes.   
   > This is a function of Visual FoxPro, not SS.   
      
   >      How to suppress SS popping up for more data on an error.  I would   
   > like to handle these errors programmatically, even if only an error   
   > message.   
      
   From VFP Help:   
   If a SQL pass-through function returns an error, Visual FoxPro stores the   
   error message in an array.   
   The AERROR( ) function provides information about errors that are detected in   
   any of the component   
   levels: Visual FoxPro, the ODBC data source, or the remote server.   
   By examining the values returned by AERROR( ), you can determine the server   
   error   
   that occurred and its error message text.   
      
   You must call AERROR() immediately to obtain error information.   
   If you generate any other error before you call AERROR(), the error   
   information is lost.   
      
   The steps to run a query or command from VFP to SQL Server:   
      
   1. Create a system DSN or create a connection string   
   2. Connect with SQLCONNECT() or SQLSTRINGCONNECT()   
   3. Set connection properties with SQLSETPROP()   
   4. Run query or send command with SQLEXEC()   
   5. Disconnect with SQLDISCONNECT()   
      
   The details and parameters of the functions depend on the case at hand.   
   There are lots of examples in VFP Help.   
   --   
   JS   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)