On Sunday 15 March 2009 8:52:17 am Sibylle Koczian wrote: > Carl Karsten schrieb: > > Carl Karsten wrote: > >> Trying to figure out how to get a Quick Report, so ran the app wiz on my > >> db, ran the app, when I hit "Requery" I get: > >> > >> c...@dv67:~/temp/er$ python er.py > >> Dabo Error Log: Sat Mar 14 23:04:01 2009: Type 'blob' not recognized. > >> Dabo Error Log: Sat Mar 14 23:04:01 2009: No control class found for > >> field 'picture_data'. > >> Dabo Error Log: Sat Mar 14 23:04:15 2009: !!! Data Type Mismatch: > >> field=donation_to_PSF. Expecting: <type 'unicode'>; got: <type 'float'> > > > > how can I get the CREATE commands so I can try re-creating this on a > > different box? > > > > $ sqlite storage.db > > Unable to open database "storage.db": file is encrypted or is not a > > database > > > > I am pretty sure it is not encrypted, and pretty sure that is a db. It is > > the same db that the Appwizard used to create the app, so it was somehow > > able to open it and get the table and field names. > > And if you enter "sqlite3 storage.db"? > > I just tried both with one of my sqlite databases and got the same > message with "sqlite dbname", but no problem with "sqlite3 dbname". > > But I don't know at all what really happens with the first command. > > HTH > Sibylle
The version 3 file format is close enough to version 2 that sqlite sort of recognizes it and presents the option of it either being encrypted or not a sqlite file ar all. -- Adrian Klaver [email protected] _______________________________________________ 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]
