[Emerald] Ugg... Playing with upgrading to 4.0 from 2.5

Billy Huddleston ( (no email) )
Mon, 15 Jul 2002 14:21:39 -0400

Getting this message when I click on a service of a MBR...

Error during query operation:
[Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to fetch logical page
(1:853) in database 'Emerald4' belongs to object 'Calls', not to object

SELECT IncidentID, CreateDate AS SortDate, CreateDate AS IncidentDate,
Operator, Convert(varchar(50),i.Description) as Description, IncidentState
as Status, IncidentType, CASE i.IncidentStateID WHEN 0 THEN 'LightBlue' ELSE
'eedddd' END AS bgcolor, (Select Count(ActionID) From Actions a Where
a.IncidentID = i.IncidentID) as Actions FROM Incidents i, IncidentStates
ins, IncidentTypes it WHERE AccountID = 1503 and i.IncidentStateID =
ins.IncidentStateID AND i.IncidentTypeID = it.IncidentTypeID ORDER BY
SortDate DESC

| Billy Huddleston Senior Systems Administrator |
| Net-Express http://www.nxs.net |
| 114 Sherway Rd. Voice: 865-691-2011 |
| Knoxville, TN 37922 Fax: 865-691-9894 |
| billy@nxs.net |


This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at

For more information about this list (including removal) go to: