tblobfield(table1.fieldbyname(file_content)).loadfromfile
tblobfield(table1.fieldbyname(file_content)).savetofile
调整blobzie blobcatch
tblobfield(table1.fieldbyname(file_content)).savetofile
调整blobzie blobcatch
// 插入一个新记录
Query->Close();
Query->SQL->Clear();
Query->SQL->Add("INSERT mytable(NO, BLOBFIELD) VALUE(:INDEX, EMPTY_BLOB())");
Query->ParamByName("INDEX")->AsInteger = No;
Query->ExecSQL();
// 修改刚才的记录,写入Blob数据
Query->SQL->Clear();
Query->SQL->Add("UPDATE mytable SET BLOBFIELD=:BLOBDATA WHERE NO=:INDEX");
Query->ParamByName("INDEX")->AsInteger = No;
Query->ParamByName("BLOBDATA")->SetBlobData(Buffer,ByteCount);
Query->ExecSQL();
有做過的老大給我貼一段好嗎???
加載blob文件.
我的程序是3層的;
server端; ADOConnection1+ADOQuery1+DataSetProvider1
client端; SocketConnection1+ClientDataSet1
我能否在client端加載blob文件??
請給出源碼好嗎???