*** 52,57 **** --- 52,62 ---- Is there a prefered way to check if a url is a duplicate before inserting a new record? + A) Create a UNIQUE index on your url column. + + eg. CREATE UNIQUE INDEX urlunique ON urltable (url) + where urlunique is an index name, urltable is the name of your table and url is the field. + ------ Q) Is there a decent Report Writer that can be used with SQLite. I would like
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|