Accessing SQL View with Python

[kyosohma]

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.

Thanks a lot!

Mike

 

[Tim Golden]

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

 

[kyosohma]

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