General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Not too sure what you mean....
But You will see that if you connect to the AS400 with SQLCON()
handle=SQLCON()
You could then
a) Insert the data via SQLEXEC commands example:
lcsql="insert into test value('xccc')"
sqlexec(Handle,lcsql)
Otherwise more info is needed.
My point being simple construct sql statement taht pull the data from teh view and pouplate the as400 with this data.
Example
* View:
* Test
* col1 number
* col2 char
select test
go top
do while not eof()
var1=col1
var2=col2
lcsql="insert into test(col1,col2) values (?col1,?col2)"
SQLEXEC(handle,lcsql)
skip
enddo
b)
What we do is export the data from VFP into an XML document and then import it with the MQ Series application
This is because we need validaction on the fields that are inserted.
It is of course considerable work to setup.
Did you get any error messages?
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