Print Thread
"DMLQuery already exists" error
#5987 02/04/04 07:35 AM
Joined: Jul 2001
Posts: 5
Chicago, IL USA
E
ehamlin Offline OP
Member
OP Offline
Member
E
Joined: Jul 2001
Posts: 5
Chicago, IL USA
Here's a weird one: we are suddenly getting an AV in a Delphi 5 app that has been running fine for some time against an 8.1.5 database. (DOA 3.4.6.) The message coming back is: A component named DMLQuery already exists. Huh? Looks like DMLQuery is part of DOA's plumbing but we have never seen this one.

We would rather not open up the code on this app if we can avoid it. Any ideas what might suddenly be causing this?

Re: "DMLQuery already exists" error
#5988 02/04/04 10:57 PM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
This error is new to me. The DMLQuery component is created dynamically by the TOracleDataSet, but there is only one and it's owned be the dataset, so there cannot be any name clash.

Maybe something goes wrong when the TOracleDataSet is closed? Do you get any other exceptions before this error occurs?


Marco Kalter
Allround Automations
Re: "DMLQuery already exists" error
#5989 02/05/04 12:05 AM
Joined: Jul 2001
Posts: 5
Chicago, IL USA
E
ehamlin Offline OP
Member
OP Offline
Member
E
Joined: Jul 2001
Posts: 5
Chicago, IL USA
No, no prior errors are shown in our log. And the SQL we were attempting to execute was just a SELECT with one bind variable. Nothing exotic at all. The code is pasted below -- have a look. There's no way to tell from our error log whether it was executing the .Open or the .Refresh when it died. tblResponse is your TOracledataset. If you have any insights we'd be most grateful....
---------------------------------
if Datamodule1.tblResponse.active = FALSE then
begin
DataModule1.tblResponse.DeleteVariables;
DataModule1.tblResponse.SQL.Clear;
DataModule1.tblResponse.SQL.Add(ResponseSQLByEntryID);
DataModule1.tblResponse.DeclareVariable('EntryID', otString);
DataModule1.tblResponse.SetVariable('EntryID', CurResponseID);
Datamodule1.tblResponse.open;
end

else
DataModule1.tblRESPONSE.refresh;

Re: "DMLQuery already exists" error
#5990 02/05/04 07:50 PM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
I don't see any problems with this. I don't assume you can provide a (small) demo project that reproduces the issue?


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.039s Queries: 14 (0.012s) Memory: 2.5082 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-20 05:25:26 UTC
Valid HTML 5 and Valid CSS