On Apr 27, 10:29 am, Tim Golden <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] 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 -- http://mail.python.org/mailman/listinfo/python-list
