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


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

Re: ODBC numerics

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: ODBC numerics
Date 2017-04-12 09:11 -0400
Organization A noiseless patient Spider
Message-ID <ocl8ru$ld$1@dont-email.me> (permalink)
References (1 earlier) <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> <nv89d0$iak$1@news.albasani.net>

Show all headers | View raw


How do I enable debug in the SQL SDK Library? The debug lines say "IFDEF 
__DEBUG__". However the program does not allow to to define "__DEBUG__"

James

On 2016-10-31 04:26 PM, Jamal wrote:
> 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