Hi All!

This problem related to VFP6 and SQL 7.

I am executing an INSERT INTO via SQLEXEC(). I am getting an error ("The server did not return a result set")

Some more details.

The insert is very simple. INSERT INTO PATIENTS (field list...) VALUES (value list...)

The table has an insert trigger on it that adds records to other tables when a patient is added.

That's about all the information I have... have any of you seen this? Any way around this without modifying the SQL Server Trigger? (I am doing a data conversion, I did not write either application and cannot touch the code for the new application.)

TIA,

Menachem