Help!!
I have a realtively simple piece of code that modifies a table. It works fine unless I include a specific column; with this column included I get the following error:
Error at line 38 of Procédure locale _InitTablesSansRubrique process.
BuildBrowsingTable function called.
file unknown in analysis, or query/view not initialized.
Technical Information
Project : SJCarrier
Dump error of module .
- WL Call:
Processing , line , thread
Function , syntax #
- Level: fatal error (EL_FATAL)
- Error Code: 70018
- WD55 Error Code: 18
- No system error code
- No system error message
- What happened?
file unknown in analysis, or query/view not initialized.
- Debug Information:
IEWDHF01
Module=
Version=
Fonction (1,105)
- Attached Information:
EIT_PATHWDD :
EIT_LOGICALTABLENAME :
EIT_PILEWL :
Procédure locale _InitTablesSansRubrique (Doublon.PROCEDURE._InitTablesSansRubrique), ligne 38
Procédure locale InitTables (Doublon.PROCEDURE.InitTables), ligne 8
Déclarations globales de Doublon (Doublon), ligne 19
Method Updates_FedEx_manifest_audit (CFedEx.Updates_FedEx_manifest_audit), ligne 11
Method Updates_FedEx_manifest_audit (CFedEx.Updates_FedEx_manifest_audit), ligne 11
Method Writes_FedEx_manifest_file (CFedEx.Writes_FedEx_manifest_file), ligne 211
Row Selection of COMBO_Task (Template_WIN_practice model) (WIN_Main.SIDE_SideBar1.COMBO_Task), ligne 23
Click BTN_LOGIN (WIN_Login.BTN_LOGIN), ligne 2
EIT_COMPOSANT :
EIT_DATEHEURE : 16/07/2008 15:22:51
- Identifier in .err: 70116
Here is the code:
PROCEDURE GLOBAL Updates_FedEx_manifest_audit(sStatus is string, nOrdercount is int)
HReadSeekFirst(ManifestAudit,ManifestAuditID,::m_nFedEx_manifest_auditID,hLockWrite)
IF HErrorLock() THEN
Error("Could not update manifest audit - call support")
RESULT(False)
END
IF HFound(ManifestAudit) THEN
ManifestAudit.AuditStatus = sStatus
ManifestAudit.OrderCount = nOrdercount
HModify(ManifestAudit)
RESULT(True)
ELSE
Error("Manifest audit record update failure - call support")
RESULT(False)
END
The field that causes the problem is ManifestAudit.AuditStatus. I can add records to the table with code, I can modify the table (including this column) using the utilities, and as I said before I can make the code work by commenting out the ManifestAudit.AuditStatus = sStatus line.
Has anyone ever seen anything like this before?
If it helps at all, AuditStatus is used in a composite key on the table.
Cheers
Reg |