Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange numbers in grid column??????
Message
 
 
To
28/07/2008 06:05:41
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01334453
Message ID:
01334482
Views:
15
The question is, which value is in the cursor?
What do you get by running
SELECT wazalt, PADR(wazalt,20) AS cwazalt, wazneu, PADR(wazneu,20) AS cwazneu  FROM mycursor
>This one makes me crazy.
>
>I fire this command via odbc to an MAXDB Database.(lomontag,lodienstag,lomittwoch... are typ fixed 11,2)
>When i browse the resultcursor everything is ok.
>For example lomontag,lodienstag,lomittwoch,lodonnerstag,lofreitag show 2.2 as value.
>wazalt = 11
>wazneu = 11
>
>Before calling the sqlcommand i do: thisform.grid1.recordsource = " "
>after calling i do: thisform.grid1.recordsource = mycursor
>
>In my grid the lomontag,lodienstag... all show 2.2 but wazalt show 10.91 and wazneu shows 10.40 ???????
>The gridcolumns 53+54 are format 99.99,inputmask 99.99
>
>what do i miss???
>
<snip>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform