Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Visual FoxPro needs .NET
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
FoxPro Dos
OS:
Windows '95
Network:
Novell 2.x
Database:
Jet/Access Engine
Divers
Thread ID:
01024102
Message ID:
01025189
Vues:
15
Jordan,

Autonumbering? Like record counting?

string lcConnectionString;
string lcSQL;
OleDbConnection oConn;

//Get the connection string and sql statement
lcConnectionString = "Provider=vfpoledb.1;Data Source='C:\\Program Files\\Microsoft Visual FoxPro 7\\Samples\\Data\\testdata.dbc';password='';user id=''";
lcSQL = "Select * from customer";

//Connect to the Database, execute the query and disconnect
//SqlConnect(), SqlExecute(), SqlDisconnect()
oConn = SqlConnect(lcConnectionString);
goView = SqlExecute(oConn, lcSQL, "CustomerList");
SqlDisConnect(oConn);

//Select the default cursor and browse it
VFPToolkit.vfpData.Select(goView);
Browse();
lnreccount = VFPToolkit.vfpData.reccount(goView)

Couldnt you just use a reccount to autonumber?
This is an example from the VFP toolkit for .NET, might I add it works great for connecting with .DBF files via oledb, and it does not require VFP dlls. Your .NET project just needs a reference it the toolkit.

I saw this link in another forum, it might be useful for you...

http://www.vistasoftware.com/apollo_net.asp
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform