D7, tADOQuery, MSSQL:
Exception: "Insufficient key column information for updating or refreshing"
когато се опитам да рефрешна tADOQuery с SQL.Text=
SELECT
dbo.vzn_sps_KlasSMC_Konsist.Id,
dbo.vzn_sps_KlasSMC_Konsist.Id_KlasSMC,
dbo.vzn_sps_KlasSMC_Konsist.Id_Konsist,
dbo.vzn_sps_KlasSMC.Name AS NameKlasSMC,
dbo.vzn_sps_Konsist.Name AS NameKonsist,
dbo.vzn_sps_KlasSMC_Konsist.ObemnoTeglo
FROM
dbo.vzn_sps_KlasSMC_Konsist
INNER JOIN dbo.vzn_sps_KlasSMC ON (dbo.vzn_sps_KlasSMC_Konsist.Id_KlasSMC = dbo.vzn_sps_KlasSMC.Id)
INNER JOIN dbo.vzn_sps_Konsist ON (dbo.vzn_sps_KlasSMC_Konsist.Id_Konsist = dbo.vzn_sps_Konsist.Id)
ползвам го в кофти контекст май :) (xDataSet е tADOQuery):
xRecNo := xDataSet.RecNo;
xDataSet.Refresh;
xDataSet.RecNo := xRecNo;
Как да го дебъгна и да видя каква информация му липсвала?
Редактирано от NikB на 06.03.09 14:08.
D7, tADOQuery, MSSQL. Except: "Insuficient key col
