I am wondering if there is any data integrity protection can be done if I allow uses to update database from mysql Control Center or Excel and any other applications that is connected to mysql thru mysql ODBC. I need to reject the action if it makes violation of the data integrity (like sth not in enum values, or some relations between tables that foreign key constraint can't protect). At this moment I have a script that takes a sql command file that intends to update the database, checks each command to see if the result of executing it would violate data integrity. The script is executed at command line. But if the update comes from windows applications, I am not sure how I can get my script working in between mysql server/client and the application. Has anyone been in the same situation as I am? Any suggestion would be very welcome. The version of mysql is 4.0.16 running on Linux redhat.
Thanks
ginger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
