My favorites
▼
|
Sign in
pyodbc
Python ODBC library
Project Home
Downloads
Wiki
READ-ONLY: This project has been
archived
. For more information see
this post
.
Search
Search within:
All issues
Open issues
New issues
Issues to verify
for
Advanced search
Search tips
Subscriptions
Issue
332
attachment: alanKontrol.py
(567 bytes)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
# -*- coding: utf-8 -*-
import pyodbc
pyodbcdb = r'C:\Users\kamil\Desktop\BD_03.05.2013.mdb'
try:
con = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=' + pyodbcdb + ';')
cur = con.cursor()
cur.execute("""SELECT UAVT_BINA.BINATUR AS UAVT_BINA_TUR, YAPI.TIP, YAPI.ID, YAPI.KIMLIKNO, YAPI.AD
FROM UAVT_BINA INNER JOIN YAPI ON UAVT_BINA.BINANO = YAPI.KIMLIKNO
WHERE (((UAVT_BINA.BINATUR)='OZEL ISYERI') AND ((YAPI.TIP)<>3));""")
print "OK"
con.commit()
con.close()
except:
print "sadsd"
Powered by
Google Project Hosting