using SQL pass through for large inserts

TheMSsForum.com: The Microsoft Software Forum

Hi,

More than one records can be retrived from back end (SQL Server) to local
VFP cursor using SPT, e.g. SQLEXEC(nCon, 'SELECT * FROM Patients',
'curPatients'). However for inserting whole VFP cursor/table in back end I
have to do one by one in a SCAN...ENDSCAN loop e.g. SQLEXE(nCon, 'INSERT
INTO Patient (Field1, Field2) VALUES (Value1, Value2)').

Source data (VFP) is large therefore is there a way to INSERT a whole VFP
cursor/table using SPT in one command?

Other option would be to leave SPT and use Remote views. Ideas ?

TIA

Kamran
Top

Re: using SQL pass through for large inserts by Gerben

Gerben
Sat Aug 07 15:00:16 CDT 2004

Hi Kamran,

Are you using VFP8+? Consider to use a cursoradaptor.

Gerben Kessen

"Kamran" <k-a-q@bigmailbox.net> wrote in message
news:el$zGHJfEHA.2028@tk2msftngp13.phx.gbl...
> Hi,
>
> More than one records can be retrived from back end (SQL Server) to local
> VFP cursor using SPT, e.g. SQLEXEC(nCon, 'SELECT * FROM Patients',
> 'curPatients'). However for inserting whole VFP cursor/table in back end I
> have to do one by one in a SCAN...ENDSCAN loop e.g. SQLEXE(nCon, 'INSERT
> INTO Patient (Field1, Field2) VALUES (Value1, Value2)').
>
> Source data (VFP) is large therefore is there a way to INSERT a whole VFP
> cursor/table using SPT in one command?
>
> Other option would be to leave SPT and use Remote views. Ideas ?
>
> TIA
>
> Kamran
>
>


Top

Re: using SQL pass through for large inserts by swdev2

swdev2
Sat Aug 14 12:14:35 CDT 2004

Kamran -
why not take your VFP table and make a DTS in SQL Server
to read the table and import the records in sql server directly ?

IF that doesn't work for you - the fastest way I know of to do inserts
is the BCP - Bulk Copy Program -
you'll need an ascii comma delimited version of your vfp table [easy to
make]

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

"Kamran" <k-a-q@bigmailbox.net> wrote in message
news:el$zGHJfEHA.2028@tk2msftngp13.phx.gbl...
> Hi,
>
> More than one records can be retrived from back end (SQL Server) to local
> VFP cursor using SPT, e.g. SQLEXEC(nCon, 'SELECT * FROM Patients',
> 'curPatients'). However for inserting whole VFP cursor/table in back end I
> have to do one by one in a SCAN...ENDSCAN loop e.g. SQLEXE(nCon, 'INSERT
> INTO Patient (Field1, Field2) VALUES (Value1, Value2)').
>
> Source data (VFP) is large therefore is there a way to INSERT a whole VFP
> cursor/table using SPT in one command?
>
> Other option would be to leave SPT and use Remote views. Ideas ?
>
> TIA
>
> Kamran
>
>


Top