Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View X SPT with trigger
Message
From
10/09/2009 08:14:27
Moacyr Zalcman
Independent Consultant
São Paulo, Brazil
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Remote View X SPT with trigger
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01423419
Message ID:
01423419
Views:
80
Hi

I use Sql Pass-Through and remote views in an application. In a table I put an insert trigger , that raises an error and rollback when some condition occurs.With the SPT I got the error in the application, but for the remote view tableupdate returns .t. even when the error occurs but I don't have the insert.
Am I missing anything? How to get the error in the remote view?

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform