Hi Tim,
Thanks for your reply.
Actually I do the following :
store sqlconnect('mylib','neg') to gnConnectHandle
if gnConnectHandle > 0 then
create sql view rgk4;
connection mylib;
as SELECT *;
FROM mylib.RGK4 Rgk4
use rgk4 in 1
dbsetprop('rgk4', 'View', 'Tables', 'Rgk4')
*dbsetprop('test.gk4nam', 'Field', ;
*'Updatablefield', .T.)&& I do'nt do this because in my remote view I already have the update checked on. for that field.
select 1
append blank
sqlexec(gnConnectHandle,"insert into rgk4 (gk4nam) values (test)")

What happens is that the remote view that I created (rgk4) on my PC is updated with the value I inserted but when I go to the AS/400 the file is not being updated.. I do not know why.???