Non-blob column..... |
|
尚未結案
|
|
juantonia
一般會員   發表：14 回覆：12 積分：5 註冊：2003-07-10 發送簡訊給我 |
|
|
hagar
版主   發表：143 回覆：4056 積分：4445 註冊：2002-04-14 發送簡訊給我 |
http://www.cbuilder.ru/faqs/faqc_en/19274.html
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
---
這次沒買到 cd-pro2 實在很 ...
|
發表時間：2004-03-19 10:59:16
IP:211.20.xxx.xxx 未訂閱
系統時間：2024-11-23 11:37:20
聯絡我們 | Delphi K.Top討論版
| 本站聲明 |
|
1. 本論壇為無營利行為之開放平台，所有文章都是由網友自行張貼，如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權，而損及您的利益，請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨，是藍是綠本站無權干涉，但這裡不是政治性論壇！ |