关于Jpg从数据库中删除问题,可以帮帮忙忙吗?(100分)

  • 主题发起人 主题发起人 xujiancai
  • 开始时间 开始时间
X

xujiancai

Unregistered / Unconfirmed
GUEST, unregistred user!
我用下面的句子吧Jpg图形存储到数据库中:
(Table1.FieldByName('Photo') as TBlobField).loadfromfile(fileName)
但我发现当我调用Table1.delete删除表中记录时,数据库容量一点都不会减少,
我特意删了几十条纪录,数据库大小没有变化。
应如何做呢?
(我用的是paradox数据库,存储jpg用graphic类型)
 
用pack,是bde api
 
看看DELPHI自己的例子:
Example 1: Pack a Paradox or dBASE table.

This example will pack a Paradox or dBASE table therfore removing already deleted rows in a table. This function will also regenerate all out-of-date indexes (maintained indexes). This example uses the following input:

PackTable(Table1)

The function is defined as follows:

// Pack a Paradox or dBASE table
// The table must be opened execlusively before calling this function...
procedure PackTable(Table: TTable);
var
Props: CURProps;
hDb: hDBIDb;
TableDesc: CRTblDesc;
begin
// Make sure the table is open exclusively so we can get the db handle...
if not Table.Active then
raise EDatabaseError.Create('Table must be opened to pack');
if not Table.Exclusive then

raise EDatabaseError.Create('Table must be opened exclusively to pack');

// Get the table properties to determine table type...
Check(DbiGetCursorProps(Table.Handle, Props));

// If the table is a Paradox table, you must call DbiDoRestructure...
if Props.szTableType = szPARADOX then begin
// Blank out the structure...
FillChar(TableDesc, sizeof(TableDesc), 0);
// Get the database handle from the table's cursor handle...

Check(DbiGetObjFromObj(hDBIObj(Table.Handle), objDATABASE, hDBIObj(hDb)));
// Put the table name in the table descriptor...
StrPCopy(TableDesc.szTblName, Table.TableName);
// Put the table type in the table descriptor...
StrPCopy(TableDesc.szTblType, Props.szTableType);
// Set the Pack option in the table descriptor to TRUE...
TableDesc.bPack := True;
// Close the table so the restructure can complete...
Table.Close;
// Call DbiDoRestructure...

Check(DbiDoRestructure(hDb, 1, @TableDesc, nil
, nil, nil, False));
end
else
// If the table is a dBASE table, simply call DbiPackTable...
if (Props.szTableType = szDBASE) then
Check(DbiPackTable(Table.DBHandle, Table.Handle, nil, szDBASE, True))
else
// Pack only works on PAradox or dBASE; nothing else...
raise EDatabaseError.Create('Table must be either of Paradox or dBASE ' +

'type to pack');

Table.Open;

end;
 
谢谢两位,特别是mataijin的例子,该问题已经解决,不过问一下,
如果采用的是access,或者ms sql7数据库,又应该怎样解决?
 
除了dbf,不必压缩,删除的空间以后又新记录添加时会利用这些空间,更快。
删除记录后不把数据库文件缩小是为了性能。
 
多人接受答案了。
 
后退
顶部