PROCEDURE GetShortNutri LPARAMETERS theFile, theField, theRecno USE &theFile. ORDER Id =SEEK(theRecno) RESTORE FROM MEMO &theField. CREATE CURSOR result (Val1 N(5), Val2 N(5)) APPEND FROM ARRAY pgndata SETRESULTSET('result') RETURN RECCOUNT('result') ENDPROCThe C# code:
using (OleDbConnection conn = new OleDbConnection(this.ConnectionString)) { DataSet ds = new DataSet(); string commandString = "GetShortNutri('" + this.TableName + "','" + this.FieldName + "'," + this.Record + ")"; conn.Open(); OleDbCommand command = new OleDbCommand(commandString, conn); command.CommandType = CommandType.StoredProcedure; var adapter = new OleDbDataAdapter(command); adapter.Fill(ds); //Exception: 'Feature not available' }SP works in VFP. All parameters are correct in the C# code (TableName and FieldName are strings; Record is int) . But 'adapter.Fills(ds)' throws the commented exception. Any suggestions ?