pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC into Access...
3+ messages / 2 participants
[nested] [flat]
* ODBC into Access...
@ 1998-04-22 12:09 The Hermit Hacker <scrappy@hub.org>
1998-04-22 15:37 ` Re: [INTERFACES] ODBC into Access... David Hartwig <daveh@insightdist.com>
0 siblings, 1 reply; 3+ messages in thread
From: The Hermit Hacker @ 1998-04-22 12:09 UTC (permalink / raw)
To: pgsql-interfaces
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?
Thanks...
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC into Access...
1998-04-22 12:09 ODBC into Access... The Hermit Hacker <scrappy@hub.org>
@ 1998-04-22 15:37 ` David Hartwig <daveh@insightdist.com>
1998-04-22 17:08 ` Re: [INTERFACES] ODBC into Access... The Hermit Hacker <scrappy@hub.org>
0 siblings, 1 reply; 3+ messages in thread
From: David Hartwig @ 1998-04-22 15:37 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: pgsql-interfaces
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.
Attachments:
vcard.vcf (text/x-vcard, 202B) download
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
* Re: [INTERFACES] ODBC into Access...
1998-04-22 12:09 ODBC into Access... The Hermit Hacker <scrappy@hub.org>
1998-04-22 15:37 ` Re: [INTERFACES] ODBC into Access... David Hartwig <daveh@insightdist.com>
@ 1998-04-22 17:08 ` The Hermit Hacker <scrappy@hub.org>
0 siblings, 0 replies; 3+ messages in thread
From: The Hermit Hacker @ 1998-04-22 17:08 UTC (permalink / raw)
To: David Hartwig <daveh@insightdist.com>; +Cc: pgsql-interfaces
On Wed, 22 Apr 1998, David Hartwig wrote:
> 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.
Generally I'd feel the same way, except, in this case, its a 130 question
questionnaire that we're loading in, and they need both "answer" and
"score" recorded :( I figured an array would be great for this, since the
only other alternative I could think of was have one table for answers and
one for scores...which I *think* would be messy :(
Access was what I was going to use for testing, but if Excel should do a
better job of it, I'll work that route instead. Worst case, I waste time
trying this and have to revert to doing it the other way *shrug*
Thanks :)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-04-22 17:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-04-22 12:09 ODBC into Access... The Hermit Hacker <scrappy@hub.org>
1998-04-22 15:37 ` David Hartwig <daveh@insightdist.com>
1998-04-22 17:08 ` The Hermit Hacker <scrappy@hub.org>
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