projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Moved all SQL statements from PHP files into relevant *_db.inc files.
[fa-stable.git]
/
sales
/
manage
/
credit_status.php
diff --git
a/sales/manage/credit_status.php
b/sales/manage/credit_status.php
index aed0b1ffc9a622d74836be1c6d083f8ffb0406f3..90fc179e4a2dc05519540ff4e3a6f0060c5b95c2 100644
(file)
--- a/
sales/manage/credit_status.php
+++ b/
sales/manage/credit_status.php
@@
-58,11
+58,7
@@
if ($Mode=='UPDATE_ITEM' && can_process())
function can_delete($selected_id)
{
function can_delete($selected_id)
{
- $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtors_master
- WHERE credit_status=".db_escape($selected_id);
- $result = db_query($sql, "could not query customers");
- $myrow = db_fetch_row($result);
- if ($myrow[0] > 0)
+ if (key_in_foreign_table($selected_id, 'debtors_master', 'credit_status'))
{
display_error(_("Cannot delete this credit status because customer accounts have been created referring to it."));
return false;
{
display_error(_("Cannot delete this credit status because customer accounts have been created referring to it."));
return false;