| Subject | Re: [ib-support] adding new constraints to an old table |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-03-02T10:54:35Z |
At 11:19 AM 02-03-02 +0100, you wrote:
clause) that sets each affected value to itself. Include an exception
handler to trap and fix any values that fail validation.
The slow way will be to open the table in your favourite interactive
utility, check each value by eye and amend the non-compliant ones manually. :))
H.
All for Open and Open for All
Firebird Open SQL Database ยท http://firebirdsql.org
_______________________________________________________
>today I had a beautiful idea or - as some malign mouths tells it - I didThe quick way will be to process the column(s) in an update (with no WHERE
>something I should have thought of long ago <g>
>
>Well anyway I added a new validity rule to an old table.
>
> From now on, FB will prevent the users to enter all sort of funny data that
>produced havoc in other parts of the application.
>
>My question is: is there any quick way to check the old records with the
>new rule ? (FB does not do that...)
clause) that sets each affected value to itself. Include an exception
handler to trap and fix any values that fail validation.
The slow way will be to open the table in your favourite interactive
utility, check each value by eye and amend the non-compliant ones manually. :))
H.
All for Open and Open for All
Firebird Open SQL Database ยท http://firebirdsql.org
_______________________________________________________