Archive | SQL

sqlite

iOS – FMDB is THE End to Your SQLite Nightmares

When you’re writing apps for iPad or iPhone, you’ve got a couple of options for you database solutions.  By far the best options (if it fits your app’s data needs) is Apple’s own Core Data which can use SQLite as it’s database store.  Core Data is fast, efficient, an object store, and provides some great integration […]

Continue Reading
relax_constraints

C# – SQL Server Foreign Key, Unique constraints

I got tripped up today with a particularly nasty Join statement that worked perfectly form 90% of the queries, but was blowing up at times.  The error message was:  Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. I looked and looked at this SQL code: It looked […]

Continue Reading

Powered by WordPress. Designed by Woo Themes