My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
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