A little more data:
I'm developing with Mono+ShatpDevelop and I rewrite some lines from VFPToolkit to fit my needs:
string lcConnectionString;
string lcSQL;
OleDbConnection oConn;
DataView goView;
lcConnectionString =
"Provider=vfpoledb.1;Data Source=" +
@"'\\wserver1\s1d2\actosa\'" +
";password='';user id=''";
lcSQL = "Select * from origen";
//Connect to the Database, execute the query and
// disconnect
//SqlConnect(), SqlExecute(), SqlDisconnect()
// must be prefaced in C#
oConn =
VFPData.SqlConnect(lcConnectionString);
goView = VFPData.SqlExecute(oConn,
lcSQL, "Actos administrativos");
VFPData.SqlDisConnect(oConn);
//Select the default cursor and browse it
VFPData.Select(goView);
VFPData.Browse();
... and it all worked fine. Now I'm trying to get the fields values to fill (for example) a Windows Form. I supposed that I could get what I need with the CURVAL function but the compiler doesn't accept curval("ID") (supposing that ID is a field) because it needs a second parameter: a ROW object. The fact is that I don't know how can I get this object.
Alberto G. García Cano