Hi,
I have Visual FoxPro 5.0 Database having proper data inserted.
I created ODBC database DSN Name "myDSN" with no user and passwod.
Following program gives me error
import odbc
import dbi
import datetime
conn = odbc.odbc("myDSN//")
cur = conn.cursor()
sql = 'Select doc_date,doc_num from transpt where doc_Type = "ZF" and '
sql = sql + ' doc_date = ? '
mydate = datetime.date(2005,4,30)
dbimydate = dbi.dbiDate(mydate)
r = cur.execute(sql,(dbiimydate,))
res = cur.fetchall()
pint res
***Program Ends
Here if statement is fired without using parameter clauses, the result is very fine. but as soon as when parameter clauses are added, the pythonwin error occurs and IDE environment terminated.
Please help me to resolve this problem
Thanks
Arvind Sidhaye
_______________________________________________ ActivePython mailing list ActivePython@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython
