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