Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #7779 > unrolled thread

Precision in SQL

Started byJames Martin <james@northwoodlumber.com>
First post2015-02-24 10:47 -0500
Last post2015-02-26 13:35 -0600
Articles 1 on this page of 21 — 6 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-24 10:47 -0500
    Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-24 15:17 -0500
    Re: Precision in SQL "Willie Moore" <williem@wmconsulting.com> - 2015-02-24 14:55 -0600
      Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-24 16:15 -0500
      Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-24 16:35 -0500
        Re: Precision in SQL Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2015-02-24 22:49 +0100
          Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-24 18:11 -0500
            Re: Precision in SQL Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2015-02-25 10:03 +0000
              Re: Precision in SQL dlzc <dlzc1@cox.net> - 2015-02-25 06:44 -0800
                Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-25 12:08 -0500
                  Re: Precision in SQL Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2015-02-26 09:32 +0000
                    Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-26 08:11 -0500
                      Re: Precision in SQL Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2015-02-26 13:31 +0000
                        Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-26 09:39 -0500
                        Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-26 11:59 -0500
                          Re: Precision in SQL Frans Wauters <info@wautersit.com> - 2015-02-26 15:25 -0800
                Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-25 13:13 -0500
                Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-25 16:15 -0500
                  Re: Precision in SQL Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2015-02-25 23:08 +0100
                    Re: Precision in SQL James Martin <james@northwoodlumber.com> - 2015-02-26 08:18 -0500
                  Re: Precision in SQL "Willie Moore" <williem@wmconsulting.com> - 2015-02-26 13:35 -0600

Page 2 of 2 — ← Prev page 1 [2]


#7807

From"Willie Moore" <williem@wmconsulting.com>
Date2015-02-26 13:35 -0600
Message-ID<mcnsih$8le$1@speranza.aioe.org>
In reply to#7797
James,

I think that the issue is your driver. I checked my app which uses MS SQL. 
The numerics come across as floats in VO.

Regards,
Willie
Vulcan VIP

"James Martin"  wrote in message news:mcldo3$9d5$1@dont-email.me...

Well it seems to come down to major changes:

1.- Use ADO and change all my numeric fields to character and convert
data as it goes and comes from the database.

2.- Get ODBC going. It works well on the terminal login I program in,
but in any other terminal I can't get ODBC to work, even if it is
configured the same. Does anyone have ideas as to what could keep ODBC
from working on other terminal logins?

James

On 15-02-25 09:44 AM, dlzc wrote:
> To the Group:
>
> On Wednesday, February 25, 2015 at 3:03:30 AM UTC-7, Malcolm G wrote:
>> On 24/02/2015 23:11, James Martin wrote:
>>> Depending on the formatting in bBrowser I get
>>> 199.00 or 199. But the AdoServer data is 199
>>
>> Sounds odd.
>>
>> I don't recognise the problem, but don't use
>> ADOServer.
>>
>> What I would do with those symptoms
>>
>> 1) look at the value of floatformat(uvalue,18,4)
>> in case there is something odd happening with
>> the display code.
>>
>> 2) Look at the table/view definition to see what
>> the column type is. float or numeric(10,2) etc
>>
>> 3) Say what version of VO I was testing with
>
> Does VO have the equivalent of SET DECIMALS?
>
> Does AdoServer configure itself automatically off data format, or does it 
> require initialization via "pictures" or similar?
>
> Is AdoServer a complied, standalone application, or a linked library?  In 
> either case, it might be hard to reveal what needs to be revealed.
>
> No response to me required... clearly.
>
> David A. Smith
> 

[toc] | [prev] | [standalone]


Page 2 of 2 — ← Prev page 1 [2]

Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web