Re: can I use ADO connection in VFP 6.0....??

thank you Cindy,

I'm looking for a way to call a SQL Server Stored Procedure through ADO.

I know how to do in VFP 6.0 with sqlexecute() but I don`t like to build the
"execute mySP pro1 , prm2" string, I prefer ADO because of the parameters
array, I try to prevent SQL injection-:)

Eusebio.




"Cindy Winegarden" <cindy_winegarden@xxxxxxx> escribió en el mensaje
news:eHsdbRGcFHA.2288@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Eusebio,
>
> Although you can use ADO in VFP, Visual FoxPro accesses data natively.
>
> *-- Open a table
> Use Customers In 0 Order CustID
> *-- Find a record
> Seek 123
> *-- Change some data
> Replace CustName With "Fred" ;
> For CustID = 123
> *-- Another way to change data
> Update Customers ;
> Set CustName To "Fred" ;
> Where CustID = 123
> *-- Close the table
> Use In Customers
>
> Can you describe in more detail what you want to do with your data?
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> <Chevy74> wrote in message news:OXNHy$FcFHA.1404@xxxxxxxxxxxxxxxxxxxxxxx
>
> > I'm a Visual Basic developer but now I need to make an app in Visual Fox
> > Pro
> > 6.0, my questios is if I can use ActiveX Data Objects (ADO) in VFP and
if
> > so
> > an exmple o a link....
>
>


.

Relevant Pages

  • Re: can I use ADO connection in VFP 6.0....??
    ... Although you can use ADO in VFP, Visual FoxPro accesses data natively. ... Use Customers In 0 Order CustID ...
    (microsoft.public.fox.vfp.forms)
  • Re: Fatal Error when using Free tables in VFP 9.0.beta
    ... If it's a network problem, whether it's a free table or in a .DBC will make ... >> Microsoft Visual FoxPro MVP ... >>> I am currently evaluating VFP 9.0 beta version. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Cannot update cursor
    ... www.foxite.com - The Home Of The Visual FoxPro Experts ... I am using VFP ... > 2.1) Repeat step 1.1, testing sort feature, all OK. ... > 3) Modify form adding a button to add a new record to the grid. ...
    (microsoft.public.fox.vfp.dbc)
  • RE: security
    ... Visual FoxPro does not offer any mechanism to prevent a user from opening ... if some one had a copy of VFP they could always issue a FREE ... TABLES command to remove the table from a database container and then view ... which offers much better security than VFP. ...
    (microsoft.public.fox.vfp.dbc)
  • Re: Rebuild DBC
    ... Make sure you have the most recent SP for your version of VFP. ... Possible Causes of Data Corruption in Visual FoxPro ... rather then reindexing the tables all the time. ...
    (microsoft.public.fox.programmer.exchange)
Quantcast