General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Joel,
First of all, at SQL Server you don't use PACK instructions (you don't need it).
You can change data on SQL Server by just using an Transact-SQL instruction (insert into a SQLEXEC() instruction on VFP).
What takes 30 minutes to load? I did not understand!
Say something.
Ricardo
-------- Your message --------
I have a MS SQL 7 database and I need to change one table and delete many records.
Can I just use a remote view in Foxpro, edit the records and delete the ones I do not want??
Then do I need to PACK the SQL table????
How I can I load an SQL table without it taking 30 minutes to load??
I setup a remote view to the table, but when I open it, it locks my machine until all of the records load and that is at least 30 minutes.
THANKS
Joel
Houston, TX
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only