BorlandTalk.com

Whym Junction · Guest

I'm trying to empty a table with the following code (some lines
regarding metadataupdate, tablename and rowid removed for brevity):

queryDataSet1.setQuery(new QueryDescriptor(database1, "select *
from some_table", null, false,Load.ALL));
queryDataSet1.setResolver(new QueryResolver());
queryDataSet1.executeQuery();
queryDataSet1.deleteAllRows();
queryDataSet1.saveChanges();

The code raises a runtime DataSetException, error code BASE+38:
More than one row was affected by resolution query:DELETE FROM
`some_table` WHERE `CaseID` = ?

I'm stumped. The resolution query seems OK. Did I forget something
obvious?

Thanks in advance,
Wim

John Moore (TeamB) · Guest

Whym,

Frankly I would never have included the line..

queryDataSet1.setResolver(new QueryResolver());

I default resolver is created as part of the QueryDataSet. Unless you
require special resolution functions (which seems you do not) I don't
see a reason for that line, (and it may be mucking things up..??)

Another possible addition is:

queryDataSet1.setRowId("CaseID", true);

It could be that the driver you are using is not reporting the metadata
correctly and therefore you need to give DX a bit more help. Otherwise
It will use ALL or SOME rows to locate the desired record to delete that
are not really key fields, depending on what has been reported by the
driver. This is not a DX problem but a driver issue.

John...

Whym Junction wrote:

Whym Junction · Guest

Hi John,

Thanks for your helpful advice. I'm still learning to use the dx
library.

I found a solution for this problem. There were had duplicate records
in my dataset, and there was no key set. Dx breaks the above query into
smaller pieces; it tries to delete records one at a time. The solution
is to make sure the records are different in at least one field or by
adding a unique key field. I'll report here if I find a way to prevent
the one-at-a-time delete strategy.

Thanks again,
Wim

John Moore (TeamB) schreef:

John Moore (TeamB) · Guest

Whym Junction wrote: