Invalid BLOB handle in record buffer 請問這是什麼意思...完全看不懂 oh~mygod

------
oh~mygod

參考底下這個問答 Q: Why am I getting the error 'Invalid BLOB Handle in record Buffer' when I attempt to modify a record containing a BLOB? A: This error can occur for two different reasons. Case 1 - BDE API Application This error is caused by not setting up the record correctly. Make certain to call DbiInitRecord on the record buffer before reading the record from the table. CASE 2 - Any BDE Application This error occurs when scrolling through more than 64 blobs in the results of a dead query. The solution is to either make the results of the query a live result set, or somehow limitscrolling blobs. (Such as having your SELECT statement select fewer records.) NOTE:A future release of the BDE is planned to be able to be configured to get past the present hard coded limit. 另外參考 http://www.delphi32.com/magazine/articles/6/bde_ora.asp 這 有問 BLOBS TO CACHE 這段的說明。 最後, 除了錯誤訊息外 說明一下您是在什麼情況下發生的 也是解決問題的重要參考。 -- Everything I say is a lie.

你在SQL Explorer中設定Alias時可以看到一欄"BLOBS TO CACHE", 預設值為64,代表最多可有64個BLOB. 因此當你OPEN一個含BLOB欄位之DataSet時, 若超過64筆資料, open時問題,只要指標移動一超過第64筆, 問題就出來了 解決方法: 1: 改BLOBS to CHCHE加大到滿足需求(最好不要如此) 2: open DataSet時不要含入BLOB field, 提供Button在click時才讀取 3: 用calculate field, 在onCalculate時讀取