Re: Using VFP Again...syntax question

Hi Bruce,

Check out the CursorAdapter in Help. It accesses data via OLE DB and shows
it as a cursor.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Bruce D" <bb@xxxxxxxxxxxxxxx> wrote in message
news:%23y9t2yg6FHA.2012@xxxxxxxxxxxxxxxxxxxxxxx
> ....what's the best way to update a table in SQL.
> I have a cursor that has about 100 - 200 rows and I want to update the SQL
> table. My previous experience tells me to create an updateable remote SQL
> view and just append the records to that remote view and SQL will be
> updated. But, I'm wondering if there is a better way...one which I can
> omit the updateable remote view?


.

Relevant Pages

  • Re: ODBC or OLE DB
    ... I'm using Native for the cursoradapter with VFP backend, and ODBC for the ... SQL and that would then use the OLE DB connection string but would that mean ... What I'm trying to do is use a consistent way of interfacing between our VFP ...
    (microsoft.public.fox.programmer.exchange)
  • how to transactions with Cursoradapters and sql
    ... I have created a CursorAdapter to insert and update multiple records in a ... After updating/inserting multiple records or so, i need to be able to roll ... even if i use a TRANSACTION in the SQL (by issuig BEGIN ... How can i rollback the changes after having issued a TABLEUPDATE? ...
    (microsoft.public.fox.helpwanted)
  • Re: Best approach to connecting to SQL Server - SQL Commands, Cursor Adapter or ADO
    ... > updates data via stored procedures, ... automatically generated SQL. ... are sure you'll stay with MS SQL Server. ... But CursorAdapter won't have more rights and be able to do more ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Using VFP Again...syntax question
    ... I have a cursor that has about 100 - 200 rows and I want to update the SQL table. ... My previous experience tells me to create an updateable remote SQL view and just append the records to that remote view and SQL will be updated. ... Regards ...
    (microsoft.public.fox.programmer.exchange)