Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view leading zero is not showing
Message
From
10/06/2008 09:20:58
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01322652
Message ID:
01322801
Views:
13
>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()  && 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
ramil
~~ learning to stand still
Previous
Reply
Map
View

Click here to load this message in the networking platform