Re: [sqlite] Fwd: database collision detection

2011-03-11 Thread Eugene N
Thank you all, Learning is such a joy when people are helpful :) Eugene 2011/3/11 Teg > Hello Eugene, > > How about initally attempting the fetch and if that fails, do the > insert? Since the results of a duplicate means you want the two > additional blobs anyway. > > Select so and so > > on e

Re: [sqlite] Fwd: database collision detection

2011-03-11 Thread Teg
Hello Eugene, How about initally attempting the fetch and if that fails, do the insert? Since the results of a duplicate means you want the two additional blobs anyway. Select so and so on empty results Insert so and so. C Friday, March 11, 2011, 9:15:14 AM, you wrote: EN> Hello EN> I am j

[sqlite] Fwd: database collision detection

2011-03-11 Thread Eugene N
Hello I am just beginning my thorn-ridden way up the steep slope with SQLite and C++ to keep me company. And i am stuck at one point, so if you could help me to continue it would be awsome. I have a database contaning a table with a layout like this: NAME PART1 PART2 blobblob blo