1

Topic: Editing of result of request about sampling

on the full.
Created request about sampling of two bound tables.
Are connected on two fields of type one to one.
In one table of a field of a tick and the record code, in the record of a field connected on the code with decryption (the name, the price....).
Now I try to edit records in request and it is not given.
It and whether should be that?
------------------------------------------------------------------------
Thanks for the answer.

2

Re: Editing of result of request about sampling

58 wrote:

Are connected on two fields of type one to one.

If it is communication on a key (consisting of two fields) or at least to unique index - it should be edited. Otherwise - request unrenewable.

3

Re: Editing of result of request about sampling

Akina;
A little did not understand... :-(

4

Re: Editing of result of request about sampling

SELECT PACIENT_DOGOVOR_MES_PODBOR_TBL.PRIMENITb, PACIENT_DOGOVOR_MES_PODBOR_TBL.DOGOVOR_NUMBER, SPR_MEDIKAMENTS_TBL.MEDIKAMENTS_NAME
FROM SPR_MEDIKAMENTS_TBL INNER JOIN PACIENT_DOGOVOR_MES_PODBOR_TBL ON (SPR_MEDIKAMENTS_TBL.KOD_MEDIKAMENTS = PACIENT_DOGOVOR_MES_PODBOR_TBL.KOD_MEDIKAMENTS) AND (SPR_MEDIKAMENTS_TBL.KOD_MES = PACIENT_DOGOVOR_MES_PODBOR_TBL.KOD_MES)
WITH OWNERACCESS OPTION;

Two fields in communication.

5

Re: Editing of result of request about sampling

I.e. communication on two keys.

6

Re: Editing of result of request about sampling

982183 wrote:

Two fields in communication.

Yes.

982183 wrote:

I.e. communication on two keys.

Is not present.
You generally do not have indexes in tables. And there should be an index (KOD_MEDIKAMENTS, KOD_MES), and unique, in each of tables. Only then communication 1:1 is possible. Now at you the correspondence condition is simple.
PS. And, by the way, in table SPR_MEDIKAMENTS_TBL you have counterparts on this pair of fields - so 1:1 it is impossible even theoretically.

7

Re: Editing of result of request about sampling

Akina, Thanks.
------------------------------------------
Above is not my comments.