Carl Karsten wrote: > kinda got it (found the CREATE script) > > c...@dv67:~/temp$ sqlite3 foo.db > SQLite version 3.6.10 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .read storage.sql > sqlite> .tables > expense_form expense_item t2_person > > CREATE TABLE t2_person( > id INTEGER PRIMARY KEY AUTOINCREMENT, > name CHAR(32), > first_name CHAR(32), > last_name CHAR(32), > badge_line1 CHAR(32), > badge_line2 CHAR(32), > email CHAR(128), > password CHAR(32), > address1 CHAR(128), > address2 CHAR(128), > city CHAR(32), > state CHAR(32), > country CHAR(32), > zip_code CHAR(32), > phone_number CHAR(32), > personal_home_page CHAR(128), > company_name CHAR(32), > company_home_page CHAR(128), > hotel CHAR(32), > include_in_delegate_listing CHAR(1), > food_preference CHAR(32), > t_shirt_size CHAR(32), > sprints CHAR(32), > attendee_type CHAR(32), > donation_to_PSF DOUBLE, > tutorials TEXT, > discount_coupon CHAR(64), > captcha CHAR(32), > amount_billed DOUBLE, > amount_added DOUBLE, > amount_subtracted DOUBLE, > amount_paid DOUBLE, > amount_due DOUBLE, > speaker CHAR(1), > session_chair CHAR(1), > manager CHAR(1), > reviewer CHAR(1), > latitude DOUBLE, > longitude DOUBLE, > checkout_status CHAR(32), > pay_token CHAR(32), > registration_key CHAR(64), > picture_data BLOB, > created_by_ip CHAR(32), > created_on TIMESTAMP > ); > > CREATE TABLE expense_form( > id INTEGER PRIMARY KEY AUTOINCREMENT, > person REFERENCES t2_person(id) ON DELETE CASCADE, > event CHAR(20), > created_on TIMESTAMP > ); > > CREATE TABLE expense_item( > id INTEGER PRIMARY KEY AUTOINCREMENT, > exp_form REFERENCES expense_form(id) ON DELETE CASCADE, > seq INTEGER, > receipt_no INTEGER, > receipt_item INTEGER, > acct_code CHAR(20), > description TEXT, > serial_no CHAR(30), > location TEXT, > amount DOUBLE > ); > > Now to try to run the Appwiz on this.
did that, did not check "include unknown datatype fields", ran the app, 2 problems: c...@dv67:~/temp/fooapp$ python fooapp.py Did "File, Open, T2_person" and see: Dabo Error Log: Sun Mar 15 12:56:51 2009: Type 'blob' not recognized. Dabo Error Log: Sun Mar 15 12:56:51 2009: No control class found for field 'picture_data'. no biggie, app is still running. hit "re-query" get Segmentation fault (core dumped) not sure who's problem this is. I am running ubuntu jaunty (beta) so my guess is it's not a dabo problem. All I really want is a .rfxml that has a sample data set for those 3 tables, and objects for each field so I can just drag them around and not have to create each one. If someone can use the CREATE commands to create the db (any engine), and do a Quick Report on the 3 tables and post the .rfxml's, I would appreciate it. Carl K _______________________________________________ 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]
