Hi Tom… by "schema", I'm assuming you are looking for the code to define the
tables? If so, here it is; if not, let me know what you are looking for…
// create the tables
[db executeUpdate:@"CREATE TABLE IF NOT EXISTS CustData (" //
one-to-many
"Customer_ID INTEGER PRIMARY KEY, " // maps to OrderInfo.Cust_ID
(auto-increment)
"BUS_NAME TEXT, "
"EMAIL TEXT, "
"PHONE TEXT, "
"SHOP_NAME TEXT, "
"SHOP_ADDR1 TEXT, "
"SHOP_ADDR2 TEXT, "
"SHOP_CITY_STATE TEXT, "
"SHOP_ZIP TEXT, "
"SHIP_NAME TEXT, "
"SHIP_ADDR1 TEXT, "
"SHIP_ADDR2 TEXT, "
"SHIP_CITY_STATE TEXT, "
"SHIP_ZIP TEXT, "
"SALES_NAME TEXT, "
"NOTES TEXT)"];
if([db hadError])
NSLog(@"Err %d : %@", [db lastErrorCode], [db lastErrorMessage]);
[db executeUpdate:@"CREATE TABLE IF NOT EXISTS OrderInfo (" //
many-to-one
"Order_ID INT PRIMARY KEY, " // 'INT' will not autoincrement
"CUST_ID INT, " // maps to CustData.Customer_ID
"ORDER_NBR TEXT, " // maps to OrderData.Order_ID
"ORDER_DATE TEXT, "
"ORDER_DEL_INST TEXT, "
"ORDER_NOTES TEXT, "
"ORDER_TERMS TEXT, "
"ORDER_VIA TEXT, "
"FOREIGN KEY(Cust_ID) REFERENCES CustData(Customer_ID))"];
if([db hadError])
NSLog(@"Err %d : %@", [db lastErrorCode], [db lastErrorMessage]);
[db executeUpdate:@"CREATE TABLE IF NOT EXISTS OrderData (" //
many-to-one
"Order_ID INT, " // maps to OrderInfo.Order_Nbr
"LINE_ITEM_NBR INTEGER PRIMARY KEY, " // auto-increment
"BOLTS TEXT, "
"COLOR TEXT, "
"STYLE TEXT, "
"PRICE DECIMAL, " // really want decimal ??? TODO
"ITEM_DEL_INST TEXT, "
"FOREIGN KEY(Order_ID) REFERENCES OrderInfo(Cust_ID))"];
if([db hadError])
NSLog(@"Err %d : %@", [db lastErrorCode], [db lastErrorMessage]);
Here are images of the data:
As I indicated, if this is not what you are looking for, let me know… I
appreciate your help… :D
Regards,
Rolf
On Jun 2, 2012, at 4:26 PM, BareFeetWare wrote:
> Hi Rolf,
>
> There's nothing inherently different about SQLite execution in Objective-C or
> on iPad.
>
> Please post a full (though brief) sample schema, including data, that
> demonstrates the issue, so we can test.
>
> Thanks,
> Tom
>
> Tom Brodhurst-Hill
> BareFeetWare
>
> --
> iPhone/iPad/iPod and Mac software development, specialising in databases
> develo...@barefeetware.com
> --
> Follow us on Twitter: http://twitter.com/barefeetware/
> Like us on Facebook: http://www.facebook.com/BareFeetWare
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
