我用adoQuery1.open时,系统报错Data Type is not Supported, 不能使用(adoquery1.fieldbyname(‘c_file) as Tblobfield).loadfromfile (self.OpenDialog1.FileName);
(adoquery1.fieldbyname(‘c_file) as Tblobfield).loadfromfile (self.OpenDialog1.FileName, ftBlob);
(adoquery1.fieldbyname(‘c_file) as Tblobfield).loadfromfile (self.OpenDialog1.FileName, ftBlob);那在这条语句之前 对adoQuery应进行怎样的操作? 我用执行 select * from C_FILE_T 语句对adoQuery进行open , 但系统报错Data Type is not Supported, 应该怎样写呢?
procedure TForm1.Button1Click(Sender: TObject); begin with DataModule1.ADOQuery_Insert do begin SQL.Clear; SQL.Text := 'insert into INVENTORY_MST (inv_code,inv_name,inv_poster) values (:vcode, :vname, :vpost)'; Parameters.Clear; Parameters.AddParameter.Name := 'vcode'; //参数定義 Parameters.AddParameter.Name := 'vname'; Parameters.AddParameter.Name := 'vpost'; Parameters.ParamByName('vcode').Value := Edit1.Text; //参数付値 Parameters.ParamByName('vname').Value := Edit2.Text; Parameters.ParamByName('vpost').LoadFromFile(Edit3.Text, ftBlob); ExecSQL; end; end;(注:給出一個例子供参考)
我用adoQuery1.open时,系统报错Data Type is not Supported, 不能使用(adoquery1.fieldbyname(‘c_file) as Tblobfield).loadfromfile (self.OpenDialog1.FileName);
select * from C_FILE_T 语句对adoQuery进行open , 但系统报错Data Type is not Supported, 应该怎样写呢?
begin
with DataModule1.ADOQuery_Insert do begin
SQL.Clear;
SQL.Text := 'insert into INVENTORY_MST (inv_code,inv_name,inv_poster) values (:vcode, :vname, :vpost)'; Parameters.Clear;
Parameters.AddParameter.Name := 'vcode'; //参数定義
Parameters.AddParameter.Name := 'vname';
Parameters.AddParameter.Name := 'vpost'; Parameters.ParamByName('vcode').Value := Edit1.Text; //参数付値
Parameters.ParamByName('vname').Value := Edit2.Text;
Parameters.ParamByName('vpost').LoadFromFile(Edit3.Text, ftBlob);
ExecSQL;
end;
end;(注:給出一個例子供参考)
Provider=OraOLEDB.Oracle.1;Password=xxx;Persist Security Info=True;User ID=xxx;Data Source=xxx;Extended Properties=""
我安装的是oracle9, windows2kProfessional
有「Oracle Provider for OLE DB」嗎?
只有Mircrosoft OLE Provider for Oracle , 请问要怎样安装Oracle Provider for OLE DB???
怎麼快GUAN上我了。(~_~)
其实也不用直接装MANAGEMENT , 选择 自定义 安装, 只要把 windows interface 选上就好了以后有问题还多请教阿
u happy , me happy , everybody happy