Message-Id: <353E0ECE.B4DA5070@insightdist.com>
Date: Wed, 22 Apr 1998 11:37:50 -0400
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
Mime-Version: 1.0
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC into Access...
References: <Pine.NEB.3.95.980422080659.6405D-100000@hub.org>
Content-Type: multipart/mixed; boundary="------------1C8455937939693C0C35C656"

This is a multi-part message in MIME format.
--------------1C8455937939693C0C35C656
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


The Hermit Hacker wrote:

> Morning...
>
>         Well, I've finally been forced to use Micro$loth for a project
> *sigh*  But, thank god, its purely to provide a front-end for a client, so
> I can live with it...
>
>         But, the question is...the table that I'm creating consists of
> fields of int4[] (an array), where element 1 is an answer, and element 2
> is a score associated with that answer...
>
>         How (if it does?) will Access be able to handle this?
>

Good Afternoon,

The driver handles all none standard data types as text.    The resulting
behavior will probably vary some with each application and data type.   In the
case of int4[] and MS Access 97 it does an effective job.     The array can be
displayed and updated cleanly.     Arithmetic is a little tricky.    MS Access
complains about "t.a[1]" in the query builder.    It does not like the syntax
and never sends it to the backend.

The work around is to choose the SQL Pass-thru option.  This will allow you to
build expressions like "t.a[0] * t.a[1]".    The hassle is that every time you
run the query in Access 97 it prompts you with a database connection dialog.

MS Excel in combination w/ MS Query may provide a better solution.  It passes
every query through.. I try to stay away from the more exotic types if I know
I am going to expose them to the public.

--------------1C8455937939693C0C35C656
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for David Hartwig
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             David Hartwig
n:              Hartwig;David
email;internet: daveh@insightdist.com
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


--------------1C8455937939693C0C35C656--