Menachem,
Can you add a record to the PATIENTS table through the enterprise manager?
Could it be a permission problem? Are you sure that the user trying to do the insert has the necessary rights to *all* the tables that the insert trigger is updating?
HTH
>>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
Daniel