Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7807
| 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> |
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
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