Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Catching field validation errors @runtime
Message
From
04/08/2005 03:03:01
 
 
To
03/08/2005 08:17:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01038068
Message ID:
01038443
Views:
12
Hi Sylvain,

You probably tried the ON Error in the VFP command window, which works @my end too. Did you try using it in the form with Table Buffering. I havent checked with TRY-CATCH, but will post my results on the UT.

rgds
sanjay




>In my test, ON ERROR did trigger for a field validation error. You can also try with a TRY-CATCH.
>
>>Is there a way to CATCH the field validation error in the VFP front end?
>>
>>For Example : my validation rule for field "QTY" is QTY>0
>>
>>Message "Qty cannot be 0"
>>
>>What i am looking is to trap the above validation error in my application. "On Error" is unable to trap the database validation errors.
Sanjay Dhiraj Patel

MCSE, MCDBA

Net2Biz (Thailand)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform