FM9 SQL problem

[sudharsan]

Hi,

I am using FM9 on OSX. I tried adding a record to a sql database from a filemaker file using the "Execute SQL" script step. Though this works and the record gets updated in the external SQL database it gives me a error message every time. The error message I get is:

ODBC Error: [Actual][sql Server] Executing sp_notify_necropsy_results...

The related contents in the log file is:

FileMaker Pro A06E5FA0 EXIT SQLError with return code 0 (SQL_SUCCESS)

SQLHENV 0x1fb70a90

SQLHDBC 0x1fb07c90

SQLHSTMT 0x1fadd170

SQLWCHAR * 0x1fb5ae10

| 01000 |

SQLINTEGER * 0xbffff0f8 (0)

SQLWCHAR * 0x1f38fc00

| [Actual][sql Server] Executing sp_notify |

| _necropsy_results... |

SQLINTEGER 350

SQLSMALLINT * 0xbffff10e (60)

Can anyone please help me find out how to avoid this warning/error. Your help will be highly appreciated.

thanks,

Sudharsan.

[BowDown]

Is your SQL Procedure returning you something that you're not handling?