Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert into table from Memvar is too slow for Fox?
Message
From
13/10/2003 17:42:22
 
 
To
13/10/2003 17:09:51
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00838321
Message ID:
00838336
Views:
19
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform