RE: [PHP-DB] MS-SQL Error Message Replacement

well, one way would be to place a check before the delete statement. check to see if there are any child records and then only send the delete statement if it is ok to delete :) -Sean -----Original Message----- From: ryan.sinn@usbank.com [SMTP:ryan.sinn@usbank.com] Sent: Wednesday, January 24, 2001 7:22 PM To: php-db@lists.php.net Subject: [PHP-DB] MS-SQL Error Message Replacement I'm working with MS-SQL 7 and IIS 4 as well as PHP4.0.4 --- My question is that when a message is received while attempting to delete a row in [table x] while it is tied to [table y.column a] by a foreign key relationship [see below] Warning: MS SQL message: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_COMPONENT_INDEX_page'. The conflict occurred in database 'corplan', table 'COMPONENT_INDEX', column 'pid'. (severity 16) in D: \Inetpub\wwwroot\admin\intranet.php on line 122 Warning: MS SQL: Query failed in D:\Inetpub\wwwroot\admin\intranet.php on line 122 How can I put in my own custom message when these errors occur? Should I be looking for a failed query message and then acting on that? I like the protection that the foreign key relationship enables, because you can't delete "parent" objects without removing the children first. I'm sure this really isn't a difficult question, I'm looking for for suggestions on how I should approach this. Thanks, Ryan Sinn US Bank -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net