Master-Detail관계에서..Master가 empty(데이타셋이 없을때)일때..



'Non Blob column in table required to perform operation' 이라는 에러가 나는군요



Master-Detail1-Detail2식으로 만들었는데..Detail1는 Detail2의 Master입니다.



Master에의해 Detail1이 없을때(empty dataset일때.) Detail2에서 에러가 발생합니다..



BDE 5.1.1 + SQL Server 2000 + Delphi5 Enterprise SP 1 + WIN2000의 환경입니다..



이 에러메세지에 대한 리포팅이 FAQ에 있는데..이에 해당하는 내용은 아닌것 같습니다..





아래 FAQ 내용

__________________________________________________________________________________

Article #19274: Non-Blob column in table required to perform operation with MSSQL

Question and Answer Database



FAQ4274B.txt - Non-Blob column in table required to perform operation



Category :Database (MSSQL)

Platform :32 Bit

Product :BC++5.x, C++Builder1.0, C++Builder3.x, C++Builder4.x, Delphi2.x, Delphi3.x, Delphi4.x, Delphi 5.x



Question:

How come I'm getting the error

"Non Blob column in table required to perform operation" when posting to my MSSQL database?



Answer:

There are two conditions where this error occurs:





You have an identity field and a field that is NOT NULL (required) and you post a record.

With BDE versions prior 5.10, all you can do is ignore the error and continue. The problem is resolved simply by getting BDE 5.10.





You have an identity field which is the primary key and a key field, you have a text field, and you post a record.

With BDE versions prior 5.10, all you can do is ignore the error and continue. If you have BDE 5.10 and Delphi, you can turn on the AutoRefresh property of your DataSet to resolve the problem.



If you have BDE 5.10 and development system other than Delphi 5, you can call DbiSetProp and set curAUTOREFETCH (which is equal to 0x00050017) to true.





C++ Builder Example:

#include "bde.hpp"

#define curAUTOREFETCH 0x00050017;

Table1->Open();

DbiSetProp(Table1->Handle, curAUTOREFETCH, TRUE);





Delphi version other than 5 example:

uses bde;

const

curAUTOREFETCH = $00050017;

...

Table1.Open;

DbiSetProp(hDbiObj(Table1.Handle), curAUTOREFETCH, Longint(TRUE))



11/16/99





Last Modified: 16-NOV-99