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