P
P
Porto_b2020-04-25 19:04:12
Delphi
Porto_b, 2020-04-25 19:04:12

Delphi MSQL2012?

There is a database and tables inside MSSQL 2012

spoiler
5ea45e09d687e954733974.jpeg


The DB normally communicates, the data shows, the data adds in tables where there are no connected keys.
But no data is added to the TAB 1 table, the input data types are the same, here is the code
...
DataModule2.ADOQuery1.Append;
DataModule2.ADOQuery1.FieldByName('id_k1').AsInteger := 0;
DataModule2.ADOQuery1.FieldByName('id_k2).AsInteger := 1;
DataModule2.ADOQuery1.Post;
DataModule2.ADOQuery1.Refresh;
...

A similar code only works for other non-connected tables. (Adds, removes)
I tried to remove the connection id_k1 with id TAB2, also the same error on the same line.

5ea45f62eb930213501878.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Porto_b, 2020-04-25
@Porto_b

Problem solved
https://www.cyberforum.ru/delphi-database/thread13...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question