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


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

Precision in SQL

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Precision in SQL
Date 2015-02-24 10:47 -0500
Organization A noiseless patient Spider
Message-ID <mci656$2bq$1@dont-email.me> (permalink)

Show all headers | View raw


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 — 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