On 15/12/2011, at 2:58 PM, Jeff Matthews wrote: > Thanks. You are putting me on track. > > Can you describe the properties, collate, nocase, restrict, etc.,
The "primary key" constraint automatically assigns a new ID to each Customer and Invoice when you insert a new row that doesn't specify a value for it. The "on delete restrict" constraint on the Invoice prevents deleting any Customer which has invoices. The "collate nocase" ensures that nocase is used to compare Customer Name, so 'tom' is treated as equal to 'Tom'. > or better yet, point me to a reference that contains a full set of features, > including these? It's just standard SQL. You can find the syntax described on the SQLite website here: http://www.sqlite.org/lang_createtable.html Here's a comparison of some GUI software that does SQLite design and data entry: http://www.barefeetware.com/sqlite/compare/?ml Please send replied to this mail list, not me directly. Thanks, Tom BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases [email protected] -- Twitter: http://twitter.com/barefeetware/ Facebook: http://www.facebook.com/BareFeetWare _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
