General information
Forum:
Microsoft SQL Server
Title:
Sql Server Triggers and vfp
Environment versions
SQL Server:
SQL Server 2005
Hi All,
We still are having problems, and everything suggested so far has not worked.
We have a TRIGGER on a table for insert. When it inserts a record (at the moment), it is suppose to print the call string so that we can be sure that it is correct, then do shellexe to the vfp dll we have made. At the moment, the only thing the dll does is create a file that contains the parameters passed by the calling program, in this case, SQL Server.
The problem is that the trigger does not print the call string, and says running query, until we kill the vfp dll, then it shows the call string.
If we take the call string into a DOS command window, and hit enter, the vfp dll runs and quits, like it is suppose to and we get a prompt back.
Why would SQL Server Trigger / VFP not work, while Dos/vfp does?
We are using a vfp 8 exe.
TIA
Beth
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only