SqlDbx
You are not logged in.
When generating a select or update statement, how about adding a WHERE clause for every field that is included in a UNIQUE index setup for that table? You could leave zero-length strings for the values. So if, for instance, you have a table which has City and State as fields in a UNIQUE index, append:
WHERE City='' AND State=''
You could get fancy, and provide a zero (without quotes, of course) if it is an integer field.
I'd leave off any Primary Keys that are integer-based, but that's me...
Offline
This is good idea for one of the next releases
Offline