Another option with VFP8 is using the CursorAdapter. Mark McCasland has created a builder that will build all the CursorAdapters for you. You can download the builder from his site for free www.mctweedle.com.

Aloha,

James
>Hi everyone,
>
>VFP6 or VFP8
>WindowXP
>MS Server 2003
>MS SQL 2000
>VPN
>
>I am a new guy to coding with MS SQL and VPN access.
>
>My client's main office using MS Server 2003 and ready to install MS SQL 2000.
>His outside office and shop will connect to main office with VPN, then run a
>
>VFP program.
>
>I think that it have to change my VPF program from useing .dbf to SQL.
>
>
>>>>>Question 1.
>Is it call "REMOTE VIEW" ?
>
>
>>>>>Question 2.
>I found some connect MSSQL ways as below:-
>
>A. -SQLSTRING(...)
> -SQLEXEC(OCON, "SELECT * FROM LEDGER_FILE WHERE LED_NO=99999" ...)
>
>B. #Define adopendynamic 2
> #Define adlockoptimistic 3
> orecordset = CREATEOBJECT("ADODB.RECORDSET")
> orecordset.OPEN("select * from
>
>LEDGER_FILE","Provider=SQLOLEDB.1;password=;persist secrity info=ture'user
>
>id=sa;initial catalog=pubs;data source=RMH;connect timeout=15",adopendynamic,
>
>adlockoptimistic)
>
> orecordset.movefirst
> orecordset.movelast
> orecordset.bof
> orecordset.eof
> orecordset.addnew
>
>The mothed (A) looks very ifficult, but the (B) is easy and as like as .dbf.
>Can you tell me, which one is correct and good for me ?
>** the no. of records in LEDGER_FILE around 50,000 - 100,000 **
>
>
>>>>>Question 3
>What is the meaning of "Provider=SQLOLEDB.1" ?
>What is the stand for ".1" ?