Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best Way to Access VFP DB from Excel -- Auto. Srv or ODB
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Divers
Thread ID:
00135361
Message ID:
00138979
Vues:
9
Rod,

Thats great, it gives me a place to start.

Thank you.


>Hi Bud,
> The best place for more info on this subject is www.microsoft.com/data.
>
>You can read documentation on ADO there.
>
>Here's a couple of ideas.
>
>
>Set oRecs = CreateObject("ADODB.Recordset")
>oRecs.Open "Select * from customer",oConn,3,3
>
>' Add a record
>oRecs.AddNew
>oRecs.name = "Dashpoint"
>oRecs.Update
>
>'Update a record
>'no edit mode necessary
>oRecs("name") = Dash Point Software, Inc."
>oRecs.Update
>
>'Delete a record
>oRecs.Delete
>
>Let me know if this is what you were looking for.
>
>Rod
Bud Wheeler
Vision Data Solutions, Inc.
Microsoft Partner

http://www.visionpace.com
Http://www.BudWheeler.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform