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


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

Re: ODBC numerics

From "Jamal" <noooospam@example.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: ODBC numerics
Date 2016-10-31 16:26 -0400
Organization albasani.net
Message-ID <nv89d0$iak$1@news.albasani.net> (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> <nv7lto$egb$1@dont-email.me>

Show all headers | View raw


Take a look at the SQL SDK class in VO, specifically the FIELDGET method.

If the field (column) is NIL, the function may return 0.
You will have to debug it the above the method and see what is being 
returned.

Most likely the issue is with the codebase DBF not VO. Doesn't that vendor 
have tools to test and display their DBF files.


Jamal

"James Martin"  wrote in message news:nv7lto$egb$1@dont-email.me...

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