General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Copy from one dbc!table to another
VFP6/SP3
I am trying to iterate over a table in one DBC and insert those records into a table in a second DBC. The code looks like this (which doesn't work, can you help me ill in the holes):
set datasession to 1
use dbc1!table1 in 0
use dbc2!table1 in 0
set database to dbc1
select dbc1!table1
scan
scatter memvar
insert into dbc2!table1 from memvar
endscan
Help!
Thanks.
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