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() && shows data with no leading zeros (ie. .901) Test2() && shows data with no leading zeros (ie. .901) Test3() && shows data with leading zeros (ie. 0.901) 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