Topic: SQL request insert and readonly-fields
Procedure (Delphi) makes in a cycle request "UPDATE OR INSERT INTO...."
How to understand/define, what this or that field is readonly?
I see that FibPlus is able to generate the correct request where there are no calculated fields where there are no fields which "came" from JOIN tables.
That it was more clear. There is a request:
SELECT A.ID; A.INPUT_DATE; A.LCD; T.NAME TYPE_NAME; A.PHONES_LIST/* calculated */ FROM APART A LEFT JOIN TYPES T ON A.ID_TYPE = T.ID
INSERT INTO APART ( ID; INPUT_DATE; LCD ) VALUES ( :ID; :INPUT_DATE; :LCD )
There are no fields TYPE_NAME and PHONES_LIST.
But at me is not present primary SQL request since I fulfill import from XML a file. In XML a file a dial-up of all fields, including TYPE_NAME, and PHONES_LIST.
And here it is necessary to understand/define somehow that TYPE_NAME and PHONES_LIST it is not necessary to import.
Access to basis where it is necessary to import the data, at the program is.