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


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

Re: ODBC numerics

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: ODBC numerics
Date 2016-10-31 10:54 -0400
Organization A noiseless patient Spider
Message-ID <nv7lto$egb$1@dont-email.me> (permalink)
References <nuvl9r$jd4$1@dont-email.me> <ae070fd2-3181-45cd-9a66-c64d8e01fb13@googlegroups.com> <nv7gls$rpr$1@dont-email.me> <nv7isb$31m$1@dont-email.me>

Show all headers | View raw


The database is DBFs by a company called Codebase. If a index is present 
then a regular DBF program cannot open them since they are a modified 
DBF. Data Architect from Advantage does open them (took a copy and 
deleted the index) The numerics that it says is Numeric,17,7

Actually to my surprise, Data Architect does open one of the DBFs. It 
shows it to be the VFP driver. I just now tried the CDX driver. Its does 
not work. It there a VFP driver?

James

On 16-10-31 10:02 AM, Johan Nel wrote:
> Martin,
>
> What is the type of the numerical columns in the database?
>
> Remember something about single float, double float issues I had long
> time ago with the VO ODBC classes.
>
> Johan
>
> On 2016/10/31 15:24, James Martin wrote:
>> I created a SQLServer with the VO editor. Then I used it in the
>> bBrowser window this way. The SQLServer uses
>> Type:Numeric,Length:15,Decimals:6 - all by default.
>>
>> LOCAL oBr                 AS bBrowser
>>     LOCAL oDB                 AS ARDETINV
>> *    LOCAL oCol                 AS bDataColumn
>> *    LOCAL oColour             AS bColorCondition
>>
>>     oDB    := ARDETINV{}
>>
>>     IF oDB:Used
>>
>>         oBr := SELF:oDCDataBrowser
>>         oBr:Editable         := FALSE
>>         oBr:CurrentMode     := #Line
>>         oBr:ViewLogicAs := #CheckBox
>>
>>         oBr:Use(oDB)
>>
>>     ENDIF
>>
>> James
>>
>> On 16-10-28 12:41 PM, dlzc wrote:
>>> Dear James Martin
>>>
>>> On Friday, October 28, 2016 at 6:54:28 AM UTC-7, James Martin wrote:
>>>> I would like some help.
>>>>
>>>> In the pass I tried to use PostgresSQL via ADO using
>>>> VO2ADO and via ODBC using the VO SQL classes. Both
>>>> times I was able to browse the databases and the
>>>> character fields showed fine. However the numeric
>>>> fields were zero. I thought there was something wrong
>>>> with the drivers for PostgreSQL.
>>>>
>>>> However I am attempting to view another database via
>>>> ODBC and I have exactly the same problem. Is there
>>>> anyone who can give some direction as to what could
>>>> be the problem. The numerics all show zero.
>>>
>>> Can you show us your browse code, and the structure of your database?
>>>
>>> David A. Smith
>>>
>
> --
> *Johan Nel*
> /Grafx Support Team (Vulcan.NET)/
> George, South Africa
>

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

ODBC numerics James Martin <james@northwoodlumber.com> - 2016-10-28 09:56 -0400
  Re: ODBC numerics dlzc <dlzc1@cox.net> - 2016-10-28 09:41 -0700
    Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2016-10-31 09:24 -0400
      Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2016-10-31 10:54 -0400
        Re: ODBC numerics "Jamal" <noooospam@example.com> - 2016-10-31 16:26 -0400
          Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-04-11 17:16 -0400
          Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-04-12 09:11 -0400
            Re: ODBC numerics "Jamal" <noooospam@example.com> - 2017-04-12 14:46 -0400
              Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-04-12 16:41 -0400
                Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-06-01 17:50 -0400
                Re: ODBC numerics "Jamal" <noooospam@example.com> - 2017-06-03 10:58 -0400
                Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-06-05 17:07 -0400
                Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-06-05 17:13 -0400
                Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-06-06 17:12 -0400
                Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-06-06 17:19 -0400
                Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-06-08 10:02 -0400
                Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2017-06-08 08:13 -0400
            Re: ODBC numerics "Karl-Heinz" <invalid@invalid.invalid> - 2017-04-13 08:08 +0200
  Re: ODBC numerics Pilks <richardp@lukhozi.co.za> - 2016-11-01 08:03 -0700
    Re: ODBC numerics James Martin <james@northwoodlumber.com> - 2016-11-01 17:24 -0400
      Re: ODBC numerics "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-11-02 08:00 +0100
        Re: ODBC numerics "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-11-02 09:48 +0100

csiph-web