小弟為了將STRINGGRID的資料列數與QUERY的一樣,所以 STRINGGRID.ROWCOUNT:=QUERY.RECORDCOUNT; 但因 QUERY.RECORDCOUNT:=-1 所以我就先 將 QUERY.LAST 再 下 STRINGGRID.ROWCOUNT:=QUERY.RECORDCOUNT; 如此資料筆數就正確,但卻出現 Invaild BLOB handle in record buffer的 錯誤..各位大大... 煩請指教 

 WITH DM DO
     BEGIN
      QRY_CUBE.Last;
      SGRID_CUBE.RowCount:=QRY_CUBE.RecordCount;
      QRY_CUBE.First;
      SGRID_CUBE.ColCount:=QRY_CUBE.FieldCount;
       WHILE NOT QRY_CUBE.EOF DO
       BEGIN                  WITH SGRID_CUBE DO
              BEGIN
                 CELLS[0,RO]:=INTTOSTR(RO);
                 CELLS[1,RO]:=QRY_CUBE.FIELDBYNAME('CRW_ORDNO').ASSTRING;
                 CELLS[2,RO]:=QRY_CUBE.FIELDBYNAME('CRW_USER').ASSTRING;
                 CELLS[3,RO]:=QRY_CUBE.FIELDBYNAME('CRW_DEPT').ASSTRING;
                 CELLS[4,RO]:=QRY_CUBE.FIELDBYNAME('CRW_PROG').ASSTRING;
                 CELLS[5,RO]:=QRY_CUBE.FIELDBYNAME('CRW_MODE').ASSTRING;
                 CELLS[6,RO]:=QRY_CUBE.FIELDBYNAME('CRW_DESC').ASSTRING;
                 CELLS[7,RO]:=QRY_CUBE.FIELDBYNAME('CRW_PROCESS').ASSTRING;
                 CELLS[8,RO]:=QRY_CUBE.FIELDBYNAME('CRW_STATUS').ASSTRING;
                 CELLS[9,RO]:=QRY_CUBE.FIELDBYNAME('CRW_RATE').ASSTRING;
                 CELLS[10,RO]:=QRY_CUBE.FIELDBYNAME('CRW_ORDNO').ASSTRING;                  END;            QRY_CUBE.Next;
        INC(RO);
       END;         END;

if you lose your step,just tango on

------
if you lose your step,just tango on

參考 BDE FAQ: 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.

謝謝hagar兄... if you lose your step,just tango on

------
if you lose your step,just tango on