"Field 'fieldname' not found" error

[slicendice]

Hi
I am running an app built using Borland Delphi 5 with an Oracle 8.1.7 back end. Every now and then, an error occurs for no apparent reason. Everything will be going OK, and then suddenly the error pops up and once it's happened once, it will then keep on happening and it doesn't seem to be possible to get rid of it. Sometimes reinstalling the app will get rid of the error, but even this does not always work.

The error is:
qryFMTree: Field 'sap_order' not found

It occurs when I try and access one of the forms in the application. I know very little about Delphi programming and don't personally have anything to do with the development of the app. I've asked the developers and none of them know why this is happening.

I've used SQL Monitor to examine the query that is being fired off in the background and it is the following:

SELECT u.sap_child_id, u.sap_child_desc, a.app_params
FROM vws_sys_sub_apps u, vws_sys_application a
WHERE u.sap_parent_id = 'CI'
AND a.app_code = u.sap_child_id
ORDER BY u.sap_order;

I've run the query from SQL*Plus and it works fine, so I'm guessing it's a Delphi problem rather than an Oracle problem.

Has anyone experienced this before? Is it a known prob with Delphi? And if so, are there any fixes for it?

Thanks very much

 

[EricDraven]

Check your query components. If they are linked to an UpdateSQL component, then the update component may be referncing the missing field. Check the Delete, Modify and Insert SQL strings of the update component for any mention of it via the Object Inspector.


"I'm a quitter. I come from a long line of quitters. It's amazing I'm here at all!

 

[lespaul]

Also check the FIELDS in the query. From the Object TreeView, one of the choices in the query object is FIELDS. There may be a field defined here that is not included in the SELECT portion of the query (especially if you change the SQL in the code)

Leslie

 

[slicendice]

OK, thanks for your help Eric/Les

I'll see if I can get one of the developers to look into it!!

Thanks again