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


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

Re: Precision in SQL

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Precision in SQL
Date 2015-02-26 08:18 -0500
Organization A noiseless patient Spider
Message-ID <mcn661$21a$1@dont-email.me> (permalink)
References (4 earlier) <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> <schsea5c3bncdl0qer2phdgd9k3760kji2@4ax.com>

Show all headers | View raw


OK, I will try a regular databrowser. I doubt there will be a difference 
because even a fieldget() from the server gives the wrong data. I doubt 
that bBrowser is the problem.

No doubt there is something wring in the connection between 
Adoconnection and the ADO driver. I don't know how you could see the 
actual data without VO2ADO.

I am experimenting with the .net driver and C#, but the processor on one 
of my computers just quit and I need to get everything working in 
Windows 8.1.

James

On 15-02-25 05:08 PM, Karl Faller wrote:
> James,
>> 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.
> I know nothing about AdoServer, but i can't imagine, that it's not
> able to correctly read numerics. BTW, presume you  talk about Vo2Ado?
> If the latter, you could contact Robert, but unfortunately for you
> he's just gone on a 2 month tour on the southern hemisphere ;-(
>
> The next thing i would try is use the Server NOT with bBrowser, but
> with a regular datawindow. If you see the same, bBrowser is faultless,
> if not, you might contact Joachim...
>
> Karl
>
>> 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 | Next 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