I'm accessing VFP data tables from an asp.net application (c#) using vfpoledb(9). Everything is working fine filling datasets, etc. But I've been looking a VFP9 (beta), and it looks like I could do allot of cool things (bypass a bunch of queries) using vfp stored procedures. I've been able to "pass" parameters, but I haven't been able to figure out how to return values from vfp (more than one) using either ExecuteScaler or ExecuteNonQuery. I understand that I could return a dataset - but I would prefer to be able to return 2 or 3 variables (or possibly an array).

Is this possible to do?

Thanks - Geoff Campbell