Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Foxhound
  Where is Foxhound?
 Foxhole
 Indonesia
 Foxhound
 To: Nathan Gloyn
  Where is Nathan Gloyn?
 Torquay
 United Kingdom
 Nathan Gloyn
 Tags
Subject: RE: Handling SQL errors
Thread ID: 33905 Message ID: 33971 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, December 05, 2003 3:17:20 PM         
   


> Ken
>
> Just to check my understaning if I'm executing SQL locally i.e. by simply calling issuing a SQL command e.g. Insert into x (a,b) VALUE (r,t) I will be able to pick up any errors generated by this command using AERROR(), or can this only be used with SQL pass-through commands?
>
> Nathan

Yes, you can pick up any error using AERROR()... and no... it not for SQL Pass Through only... If you are using Remote View, and then you issuing TableUpdate() and it fail, you can use the same method to retrieve error. AERROR() or MESSAGE()

FoxHound
---------------------------------------------------------
Staying in your foxhole can not help you mastering foxpro
but stop being an ...hole can help you become a pro

ENTIRE THREAD

Handling SQL errors Posted by Nathan Gloyn @ 12/4/2003 9:08:06 PM
RE: Handling SQL errors Posted by Ken Blum @ 12/4/2003 9:30:28 PM
RE: Handling SQL errors Posted by Foxhound @ 12/5/2003 9:28:37 AM
RE: Handling SQL errors Posted by Nathan Gloyn @ 12/5/2003 1:50:05 PM
RE: Handling SQL errors Posted by Foxhound @ 12/5/2003 3:17:20 PM