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