On 08/25/2010 03:16 PM, Paul McNett wrote: > On 8/25/10 3:09 PM, Jeff Johnson wrote: > >> What is wrong with the statement below? >> >> Traceback (most recent call last): >> File >> "C:\Python25\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", >> line >> 312, in RunScript >> exec codeObject in __main__.__dict__ >> File "D:\_vfp7dev\Dpwin\pdf\dpwin2pdf.py", line 27, in<module> >> cur.execute(cheader % item) >> File "D:\dabo\db\dCursorMixin.py", line 332, in execute >> raise dException.DBQueryException(errMsg, sql) >> DBQueryException: no such column: '0003110', '08/17/2006', '07', '00', >> '60', '0.0', '0', '0.000000', '0.00', 'Y', 'N', 'N', 'N', '08/17/2006', >> '20060817', '004011', '1', '1480', '', '', '/ / : :', '112977', >> ' ', '0003110', 'Login/Paperwork' >> >> >> >> SQL: insert into dctemp (employee, paydate, payevent, paycode, paymins, >> paymiles, payquant, payrate, payamount, team, trainer, trainee, >> routepro, trandate, tripdate, tripno, tripq, tripseq, routeid, edituser, >> edittime, iddcpay, status, namesort, codesort) values (['0003110', >> '08/17/2006', '07', '00', '60', '0.0', '0', '0.000000', '0.00', 'Y', >> 'N', 'N', 'N', '08/17/2006', '20060817', '004011', '1', '1480', '', '', >> '/ / : :', '112977', ' ', '0003110', 'Login/Paperwork']) >> >> Is it the list of values? How do I turn ['0003110','08 ...... ] into >> '0003110',08..... >> > Yes, you need to convert your list into a string. But now I have a few > questions: > > + Who/what is generating this SQL? > > + What is making this go through pywin.RunScript? > > + Do you really mean for all those fields to be string type? > > Paul: What I am doing is creating an sqlite table from a VFP table and populating it to create pdf's from a VFP table. I have looked at all of the pdf options but since I like using the Dabo report writer it is my choice. The VFP data is in a csv file which I am trying to import into sqlite.
Thanks, -- Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
