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
How come I'm getting the error
"Non Blob column in table required to perform operation" when posting to my MSSQL database?
There are two conditions where this error occurs:
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.
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.
#define curAUTOREFETCH 0x00050017;
DbiSetProp(Table1->Handle, curAUTOREFETCH, TRUE);
curAUTOREFETCH = $00050017;
DbiSetProp(hDbiObj(Table1.Handle), curAUTOREFETCH, Longint(TRUE))
Last Modified: 16-NOV-99