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


Groups > comp.lang.clipper.visual-objects > #7807

Re: Precision in SQL

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Precision in SQL
Date 2015-02-26 13:35 -0600
Organization Aioe.org NNTP Server
Message-ID <mcnsih$8le$1@speranza.aioe.org> (permalink)
References (3 earlier) <acspea1t0bkmvv0msbv1bmpl4oq9e2d0uc@4ax.com> <mcj054$nm6$1@dont-email.me> <R5hHw.131581$C91.89107@fx22.am4> <6c2bab78-268c-4ff9-acd7-848ba040b966@googlegroups.com> <mcldo3$9d5$1@dont-email.me>

Show all headers | View raw


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
> 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

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

csiph-web