- var
- sBlobFieldList : TStringList;
- sTableName : string;
- aCommand : BDPCommand;
- aConnection : BDPConnection;
- aDataReader : BDPDataReader;
- i : integer;
- begin
- aConnection := BDPConnection.Create('assembly=Borland.Data.Oracle'
- +', Version=2.5.0.0, Culture=neutral, PublicKeyToken=91d62ebb5b0d1b1b;'
- +'vendorclient=oci.dll;pooling=True;grow on demand=True;'
- +'database=DBNAME;username=USERNAME;max pool size=100;'
- +'password=PASSWORD;provider=Oracle');
- aConnection.Open();
- sBlobFieldList := TStringlist.Create();
- sTableName := UpperCase(Edit1.Text);
- aCommand := BDPCommand.Create(Format('SELECT * FROM %s WHERE 1=0',[sTableName]),aConnection);
- aDataReader := aCommand.ExecuteReader();
- //找出BLOB字段
- for I := 0 to aDataReader.FieldCount - 1 do
- begin
- if aDataReader.GetDataType(i) = BdpType.Blob then
- begin
- sBlobFieldList.Add(aDataReader.GetName(i));
- end;
- end;
- aDataReader.Close();
- aDataReader.Dispose();
- aCommand.Close();
- aCommand.Dispose();
- aConnection.Close();
- aConnection.Dispose();
- end;
BDP.net 判断某个列是不是BLOB
最新推荐文章于 2022-10-26 09:24:45 发布