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


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

Re: ODBC numerics

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

Show all headers | View raw


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
>

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