From: | "Greg Campbell" <greg(dot)campbell(at)us(dot)michelin(dot)com> |
---|---|
To: | Andrew Ayers <aayers(at)eldocomp(dot)com> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: ADO Case Sensitivity in Win2000/XP |
Date: | 2003-09-10 17:27:49 |
Message-ID: | 3F5F5F15.6EFA42D8@us.michelin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Thanks for the feedback, but perhaps I missed something.
What setting in PG addresses this?
and by the way,
Yeah, I learned to bunch all the SQL interfacing into locales I refer to
as DB lib files. I usually do about one file per table that has the
database interfacing code for most SELECTs, INSERTs, UPDATEs, and
DELETEs. I call these functions from all the user interface code pages.
Andrew Ayers wrote:
>
> Greg Campbell wrote:
> [snip]
> > The ODBC driver is seeing lower case and I have to double-quote the
> > lower case in the string to make it work. Lower-casing and
> > double-quoting all tables names and field name is the kind of backend
> > specific sql changing I wanted to avoid. Is there a setting on the ODBC
> > Driver for Windows that will recognize the mixed case properly?
>
> IIRC, the setting isn't in the ODBC driver settings, but rather in the
> setup of PG.
>
> Strangely enough, with my application I converted a bunch of Access
> tables to PG, and noticed that on the backend, all of them seemed to be
> lowercased (from the POV of psql). On the frontend (a VB6 app), the SQL
> selects and such were mixed case (as that is how the original Access
> tables were defined), but the driver handles it all fine (I am using a
> DSN-less connection, so no special flags are being sent in the
> connection string, other than setting ksqo to false).
>
> One thing to learn from this for future applications is to instead of
> explicitly performing the SQL selects everywhere, have an include with a
> function or something you can call, passing the SQL statement, and
> returning something (the recordset or something, maybe). Everytime you
> do a select, call this function with your SQL statement. Then, if in the
> future you need to do something that will change every statement, you
> can re-parse and change the statement in that one function, instead of
> contemplating changing multiple areas throughout your code. If you find
> that despite what you do, you still need to make the change you
> outlined, perhaps now is the time to do this centralized function.
>
> Andrew Ayers
> Phoenix, Arizona
> >
> >
> > ***************************************************************
> > This email and all files transmitted with it are
> > confidential and intended solely for the use of the
> > individual or entity to whom they are addressed. If you
> > are receiving this email in error please notify the
> > system manager.
> >
> > This footnote also confirms that this message
> > has been swept for the presence of computer viruses.
> > ***************************************************************
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> -- CONFIDENTIALITY NOTICE --
>
> This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.
***************************************************************
This email and all files transmitted with it are
confidential and intended solely for the use of the
individual or entity to whom they are addressed. If you
are receiving this email in error please notify the
system manager.
This footnote also confirms that this message
has been swept for the presence of computer viruses.
***************************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | John K. Herreshoff | 2003-09-11 00:28:37 | Re: Large Object Problem: solution |
Previous Message | Oliver Elphick | 2003-09-10 17:27:19 | Re: ADO Case Sensitivity in Win2000/XP |