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


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

Re: Precision in SQL

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!news2.arglkargh.de!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Precision in SQL
Date Tue, 24 Feb 2015 14:55:04 -0600
Organization Aioe.org NNTP Server
Lines 25
Message-ID <mciofd$1dq$1@speranza.aioe.org> (permalink)
References <mci656$2bq$1@dont-email.me>
NNTP-Posting-Host uZe1054xGXxv2owlFu/2Zg.user.speranza.aioe.org
Mime-Version 1.0
Content-Type text/plain; format=flowed; charset="utf-8"; reply-type=response
Content-Transfer-Encoding 7bit
X-Complaints-To abuse@aioe.org
X-MimeOLE Produced By Microsoft MimeOLE V15.4.3555.308
X-Notice Filtered by postfilter v. 0.8.2
X-Newsreader Microsoft Windows Live Mail 15.4.3555.308
Importance Normal
X-Priority 3
X-MSMail-Priority Normal
Xref csiph.com comp.lang.clipper.visual-objects:7785

Show key headers only | View raw


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