On Wed, Aug 4, 2010 at 8:49 PM, Richard Broersma
wrote:
> On Wed, Aug 4, 2010 at 3:41 PM, Peter Koczan wrote:
>
>> Yep, that's the stumbling block we're running into. ODBC and these
>> fields' assumptions of true/false are at odds. I'm trying a few other
>> things with casts in the meantime to se
Peter Koczan writes:
> On Wed, Aug 4, 2010 at 4:40 PM, Richard Broersma
> wrote:
(...)
>> I know that there is a setting in the ODBC driver for true = -1 but it
>> doesn't work well. I also remember that filters didn't work on mapped
>> boolean columns.
>
> Yep, that's the stumbling block we're
On Wed, Aug 4, 2010 at 3:41 PM, Peter Koczan wrote:
> Yep, that's the stumbling block we're running into. ODBC and these
> fields' assumptions of true/false are at odds. I'm trying a few other
> things with casts in the meantime to see if they'll work.
Well there is a solution that I've been toy
On Wed, Aug 4, 2010 at 4:40 PM, Richard Broersma
wrote:
> On Wed, Aug 4, 2010 at 1:24 PM, Justin Graf wrote:
>
>> My memory is fuzzy but there are some additional settings in Access that
>> allows data type mapping...
>
> My experience is that PostgreSQL Integer types work the best for
> MS-Acces
On Wed, Aug 4, 2010 at 1:24 PM, Justin Graf wrote:
> My memory is fuzzy but there are some additional settings in Access that
> allows data type mapping...
My experience is that PostgreSQL Integer types work the best for
MS-Access bit datatype considering the fact that in Access -1 = true.
I kn
On 8/4/2010 1:56 PM, Richard Broersma wrote:
> On Wed, Aug 4, 2010 at 11:51 AM, Peter Koczan wrote:
>
>
>> This is one of my first forays into ODBC, so I didn't know that was a
>> possibility. Is there any place where these are documented? Searching
>> for ODBC options yields info on connectio
On Wed, Aug 4, 2010 at 11:51 AM, Peter Koczan wrote:
> This is one of my first forays into ODBC, so I didn't know that was a
> possibility. Is there any place where these are documented? Searching
> for ODBC options yields info on connection options, but none on
> behavior that I could find.
I k
On Wed, Aug 4, 2010 at 12:47 PM, Richard Broersma
wrote:
> On Wed, Aug 4, 2010 at 10:31 AM, Peter Koczan wrote:
>
>> One of the snags that's popped up is that there's some incompatibility
>> between data types. Specifically, many fields are the Sybase type
>> "bit", which is basically a boolean,
On Wed, Aug 4, 2010 at 10:31 AM, Peter Koczan wrote:
> One of the snags that's popped up is that there's some incompatibility
> between data types. Specifically, many fields are the Sybase type
> "bit", which is basically a boolean, but it accepts and displays
> bareword 1 and 0 instead of 't' an
Hi all,
I'm working on porting an old MS Access form application from Sybase
to postgres/ODBC as part of a larger database port project.
One of the snags that's popped up is that there's some incompatibility
between data types. Specifically, many fields are the Sybase type
"bit", which is basical
10 matches
Mail list logo
