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


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

Re: Precision in SQL

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Precision in SQL
Date 2015-02-24 16:15 -0500
Organization A noiseless patient Spider
Message-ID <mcipcr$oag$1@dont-email.me> (permalink)
References <mci656$2bq$1@dont-email.me> <mciofd$1dq$1@speranza.aioe.org>

Show all headers | View raw


Thanks for that answer. It is just the numerics that are a problem.

I will check and get back.

James

On 15-02-24 03:55 PM, Willie Moore wrote:
> James,
>
> It has been a long time since I have used ADOServer. Have you tried a
> simple console app first to make sure what the ADOServer is returning. I
> believe that there is a sample included in VO2ADO that you can modify to
> just print out the contents of a table.
>
> Regards,
> Willie
> Vulcan VIP
>
> "James Martin"  wrote in message news:mci656$2bq$1@dont-email.me...
>
> Can someone give me a quick answer? When browsing a SQL database with
> bBrowser and Adoserver, all the numbers are rounded to the nearest whole
> number instead of the required decimal points. They are correct in the
> database, and I put populated the database from a DBF using SQL commands
> via the Adoconnection. Somewhere in the retrieval the decimal portion is
> lost. I have initialized the Adoservers myself, and I tried to use
> SetDataField()
>
> Thanks.
>
> James

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