quMaster: Key field 'deptno' not found

halenpolen · Post by **halenpolen** » Wed 17 Nov 2010 00:47

Hi i used this demo
Demos\Win32\Miscellaneous\FailOver,

I set quMaster.keyfield:='deptno';

I click kill session,then I click refresh the table quMaster (quMaster.refresh)

The first time i set RetryMode:=rmRaise; (or choose combo box Raise)
after error message I click refresh the table quMaster,
The Second time i set RetryMode:=rmReconnectExecute; I think table quMaster should fill with new data but I get error :
'Exception class EDatabaseError with message 'quMaster: Key field 'deptno' not found'. Process FailOver.exe (3664)'

halenpolen · Post by **halenpolen** » Wed 17 Nov 2010 06:25

To Back the normal , I must close the table(DM.quMaster.Close;) and open it. (DM.quMaster.Open;)

AlexP · Post by **AlexP** » Wed 17 Nov 2010 11:13

Hello,

Please check that you set the quMaster.keyfield property correctly, this error arises when the quMaster.keyfield property is set to a field that does not exist.
Please click refresh without killing session and you will still get the same error.

halenpolen · Post by **halenpolen** » Wed 17 Nov 2010 12:12

AlexP wrote: Please check that you set the quMaster.keyfield property correctly, this error arises when the quMaster.keyfield property is set to a field that does not exist.
Please click refresh without killing session and you will still get the same error.

I already checked its no wrong with my database and table.
I click refresh/open without killing session no error, run normally.

If I click killing session then refresh
the FIRST time I choose RetryMode->Raise;
the SECOND time I choose RetryMode->ReconnectExecute;
Then table quMaster cann't use again

I used UNIDAC 3.50.0.13, MSQLSERVER2008.
I set quMaster.keyfield:='deptno'; at design time

AlexP · Post by **AlexP** » Wed 17 Nov 2010 14:59

Hello,

Unfortunately, I can not reproduce the problem.
I have conducted the same test as you did, but I did not get this error.
Please specify your email address and I will send you the complete test project to check this problem. Maybe your source code code of the demo is corrupted.

halenpolen · Post by **halenpolen** » Thu 18 Nov 2010 01:20

AlexP wrote: I have conducted the same test as you did, but I did not get this error.
Please specify your email address and I will send you the complete test project to check this problem. Maybe your source code code of the demo is corrupted.

I used UNIDAC 3.50.0.13 demos, install to delphi 2007 and XE,not change any setting, only set quMaster.keyfield:='deptno'; at design time.
If I not set quMaster.keyfield:='deptno'; the table quMaster run with no error

my email:
[email protected]

Dimon · Post by **Dimon** » Thu 18 Nov 2010 15:43

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.