00001
00002
00003
00004
00005
00006
00007 import adodb,adodb_mxodbc,datetime
00008
00009 try:
00010 True, False
00011 except NameError:
00012
00013 True, False = 1, 0
00014
00015 class adodb_vfp(adodb_mxodbc.adodb_mxodbc):
00016 databaseType = 'vfp'
00017 dataProvider = 'mxodbc'
00018 sysDate = 'date()'
00019 sysTimeStamp = 'datetime()'
00020 replaceQuote = "'+chr(39)+'"
00021
00022 def _newcursor(self,rs):
00023 return cursor_vfp(rs,self)
00024
00025 class cursor_vfp(adodb_mxodbc.cursor_mxodbc):
00026 def __init__(self,rs,conn):
00027 adodb_mxodbc.cursor_mxodbc.__init__(self,rs,conn)
00028 self._rowcount = rs.rowcount
00029
00030 if __name__ == '__main__':
00031 db = adodb_vfp()
00032 db.Connect("Driver=Microsoft Visual FoxPro Driver;UID=;PWD=;SourceDB=D:\\inetpub\\adodb\\adoxyz.DBC;SourceType=DBC;Exclusive=No;BackgroundFetch=No;Collate=Machine;Null=Yes;Deleted=Yes;")
00033 adodb.Test(db)