Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Microsoft SQL Server
>Simplified
>use table.dbf
>
>go top
>scan
>INSERT INTO sqltablepersons where person1 from dbf
IF by that you mean
INSERT INTO sqlTablePersons (field1, field2) ;
SELECT field1, field2 from person2 ;
where personid = person2
You will need an index on the VFP DBF for your person id field.
>INSERT INTO sqltablepersons where person2 from dbf
>INSERT INTO sqltablepersons where person3 from dbf
>insert into sqltablevehicle
>insert into sqltableletter
>
>endscan
>
>I am also doing some seeks into other dbf's during the scan and a couple sql select statements to see if records already exist in the sql tables before inserting, eveything runs efficiently except the sql inserts
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement