Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stuck with VFPToolkit
Message
From
02/03/2005 13:11:41
 
 
To
02/03/2005 12:51:08
General information
Forum:
ASP.NET
Category:
Visual FoxPro Toolkit for .NET
Environment versions
Environment:
C# 1.1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00992071
Message ID:
00992082
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform