From: Ken J. Wright <ken@ori-ind.com>
To: Didier Gasser-Morlay <didierg@visualgroup.com>
Cc: pgsql-interfaces@postgreSQL.org, Byron Nikolaidis <byron.nikolaidis@home.com>
Subject: Re: [INTERFACES] ODBC oin Windows
Date: Fri, 07 Jan 2000 13:49:29 -0800
Message-ID: <3.0.32.20000107134923.008f7bc0@ren.cncware.com> (raw)
At 09:12 01/07/2000 +0000, Didier Gasser-Morlay wrote:
>In a tdbgrid component.
Just to confirm, you're checking the data type by looking at
dbgrid.fields[x].datatype/size?
>I have now tried the Numeric data type (as advised by Michael J davis)
>as in Numeric (10,2). D4 sees it as a char(255) !!!!
This is a driver issue.
**
Byron, the decimal (numeric) type has never been added to the driver.
**
Your driver setting is probably set to convert unknowns to maxvarchar,
which the BDE converts to char(255). That's where I don't like the BDE. It
does things for you that you are not aware of.
Along with the links that Sergio sent, also look at
http://www.odbcexpress.com for an industrial strength odbc api for Delphi.
Not free however.
>I am using PG 6.5.1 should I upgrade to 6.5.3 or to that respect would
>there be NO difference ?
No difference.
Ken
>
>Didier
>
>
>
>"Ken J. Wright" wrote:
>>
>> >1. Money type is seen has a float. Delphi complains when trying to post
>>
>> Use the decimal type from 6.5.x
>>
>> >2. Int8 is seen as a 17 byte string
>> >3. float4 is seens as using 8 bytes (as float8)
>>
>> How are you viewing this data? Delphi provides casting methods
>> (AsString,AsFloat,etc) to convert a fields raw data to an appropriate data
>> type for your app.
>>
>> f := Dataset.FieldByName('SomeField').AsFloat;
>>
>> Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ken@ori-ind.com, didierg@visualgroup.com, byron.nikolaidis@home.com
Subject: Re: [INTERFACES] ODBC oin Windows
In-Reply-To: <3.0.32.20000107134923.008f7bc0@ren.cncware.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox