>Is it the same in a grid?
Yes, it's the same editor (grid) code. we've set our application so you can change the datasource. Even when I just made a code snippet as simple as this:
close databases all
create database test
set database to test
cConnString = "driver=Oracle in OraHome92;DBQ=ora01;UID=user01;PWD=pass01;server=ora01;"
create connection "test" connstring cConnString
nConn = sqlconnect("test")
Test1()
Test2()
Test3()
function Test1()
if sqlexec(nConn,"select whseid,prodid,netr2,bestadjr2 from p6new_regtest.opcombo")>0
browse
else
messagebox(message())
endif
endfunc
function Test2()
create sql view test_ remote connection test shared as select whseid,prodid,netr2,bestadjr2 from p6new_regtest.opcombo
use test_
browse
endfunc
function Test3()
select whseid,prodid,netr2,bestadjr2 from d:\data\p6p\datasets\zone19\opcombo
endfunc
ramil
~~ learning to stand still