I am currently trying to execute a stored procedure on an Informix database, from Visual Foxpro 5 using ODBC SQL pass through and Informix-CLI 2.5.

I have found various bits of info on calling stored procs, unfortunatley most of the examples use SQL Server syntax.

To compound the problem I have to pass a string of 256 chars to the procedure and return an integer value, indicating the result.

Hope you can help.