On 8/25/10 3:55 PM, Jeff Johnson wrote: > 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.
Here's an overview of what I would do: 1) create your sqlite database and tables manually, with the needed structure. 2) using csv.DictReader(), iterate the rows of the input csv file(s) and insert into sqlite. 3) create a dabo.dBizobj for each table. 4) use biz.getDataSet() to get the Cursor for the report. You could do 3 and 4 manually, and skip the bizobj thing, but I'd go ahead and do it especially if there's a chance you'll re-use the bizobj(s) at a later date. If you want to quickly create the bizobjs you could run AppWizard against your database... you'll get a table maintenance app for free too! ;) Paul _______________________________________________ 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]
