DELETE FROM ch From CallHistory ch, SubAccounts sa Where sa.CustomerID =
2363 And sa.AccountID = ch.AccountID
In Errors:
General SQL Server error: Check messages from the SQL Server.
When running directly in SQL the statement:
DELETE FROM ch From CallHistory ch, SubAccounts sa Where sa.CustomerID =
2363 And sa.AccountID = ch.AccountID2
I get:
Msg 208, Level 16, State 1
Invalid object name 'CallHistory'.
Any ideas?
Thanks!
Humberto Guzman
----- Original Message -----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Wednesday, January 12, 2000 1:19 PM
Subject: Re: [Emerald] Error Deleting MBR
| Humberto Guzman wrote:
| >
| > When trying to delete ANY MBR I get "Error Deleting CallHistory"
| >
| > Also, when I try to view the Call History tab for any server I get the
error
| > "Error in SQL Statement!"
|
| Can you turn debug on for me and see what the actual SQL error
| is? Someone alluded to Payments, but I'm just not making the
| connection here. Nothing should reference the CallHistory
| table, so there should not be a FK error.
|
|
| --
|
| Dale E. Reed Jr. Emerald and RadiusNT
| __________________________________________
| IEA Software, Inc. www.iea-software.com
|
| For more information about this list (including removal) go to:
| http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart