On Apr 27, 10:29 am, Tim Golden <m...@timgolden.me.ukwrote:
kyoso...@gmail.com wrote:
Hi All,
I need to access a Microsoft SQL database View. Is there a way to do
this with Python? I have done a fair share of "googling" and found
nothing on accessing Views, just executing SQL, which I already know
how to do.
I am running Windows XP, Python 2.4.
Absolutely loads of ways. But (unless I'm missing
something here) they all involve executing SQL
which accesses a View (such as: SELECT * FROM v_info).
Have I missed the point of your question?
TJG
I figured there was. And yes, I knew you'd need to use SQL to get at
the View. I just re-ran it and discovered that I am quite good at
typos. I corrected the SQL and it seems to be working now.
Thanks for the help.
Mike