Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert into table from Memvar is too slow for Fox?
Message
De
13/10/2003 17:42:22
 
 
À
13/10/2003 17:09:51
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00838321
Message ID:
00838336
Vues:
18
>This code is in a Do while that steps down through a Fox table.
>
>
>INSERT INTO sql_jdearfeederrecords FROM memvar
> WAIT WINDOW "Updating" TIMEOUT 5
>
>
>If I do not have the wait of a full 5 seconds, the next pass through I get an error say "Connection mydsn is busy"
>
>Is FOX just too fast for SQL 2000?
>
>using VFP 8.1 SQL 2000

Is this an attempt at getting around your append from problem?
If it is, please keep messages together in the same thread, as it allows you to get better help.

If it's not, try append from :)
Or, since you're using VFP8, you can use insert into x select .... like in SQL Server.
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform