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

Reply via email to