如何获取某个表的各列的名称和字段类型? 如何获取某个表的各列的名称和字段类型?最好能够提供源代码谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 table.fieldstable.fieldbyname('').datatype table.fieldbyname('columnname').fieldname //字段名称table.fieldbyname('columnname').classname //字段类型 我就是想用OpenSchema 的方式获得某个表的信息,但是调用出错了var Filter: OLEVariant;begin Filter := VarArrayCreate( [0, 2], varVariant); Filter[2] := 'Leader'; DataModule1.LeaderConnection.OpenSchema(siColumns, Filter, EmptyParam, ADODataSet1);end unit Unit1;interfaceuses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, DB, DBTables;type TForm1 = class(TForm) Table1: TTable; DataSource1: TDataSource; ListBox1: TListBox; procedure FormCreate(Sender: TObject); procedure ListBox1Click(Sender: TObject); private { Private declarations } public { Public declarations } end;var Form1: TForm1;implementation{$R *.dfm}procedure TForm1.FormCreate(Sender: TObject);begin table1.GetFieldNames(listbox1.Items);end;procedure TForm1.ListBox1Click(Sender: TObject);begin if table1.Active=false then table1.Open; if table1.FindField(listbox1.Items.Strings[listbox1.itemindex]).DataType=ftString then showmessage('整形');end;end.类型这么多 TFieldType = (ftUnknown, ftString, ftSmallint, ftInteger, ftWord, ftBoolean, ftFloat, ftCurrency, ftBCD, ftDate, ftTime, ftDateTime, ftBytes, ftVarBytes, ftAutoInc, ftBlob, ftMemo, ftGraphic, ftFmtMemo, ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftFixedChar, ftWideString, ftLargeint, ftADT, ftArray, ftReference, ftDataSet, ftOraBlob, ftOraClob, ftVariant, ftInterface, ftIDispatch, ftGuid, ftTimeStamp, ftFMTBcd); 新人请教(关于枚举变量的使用问题) 关于线程引发Access violation at address的问题 ICS的问题 求助,delphi套接字报错. DELPHI+ADO+MYSQL的中文问题! 数据库的备份和导入问题 怎样控制IE的行为,一定给分 Delphi 中有没有类似java中stringbuffer的东西。 如何得到系统的临时目录? 我在程序原码文件误删(在调试程序时),天呀块块就我呀 新病毒!!!!大家小心!!!数量不断递增!!!现在你的机子都染了吧!!csdn有可能因此瘫痪!!!! 急!急!急!高分求助数据库保存问题,分不够再加,再现等待。
table.fieldbyname('columnname').classname //字段类型
var
Filter: OLEVariant;
begin
Filter := VarArrayCreate( [0, 2], varVariant);
Filter[2] := 'Leader';
DataModule1.LeaderConnection.OpenSchema(siColumns, Filter, EmptyParam, ADODataSet1);
end
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, DB, DBTables;type
TForm1 = class(TForm)
Table1: TTable;
DataSource1: TDataSource;
ListBox1: TListBox;
procedure FormCreate(Sender: TObject);
procedure ListBox1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.FormCreate(Sender: TObject);
begin
table1.GetFieldNames(listbox1.Items);
end;procedure TForm1.ListBox1Click(Sender: TObject);
begin
if table1.Active=false then table1.Open;
if table1.FindField(listbox1.Items.Strings[listbox1.itemindex]).DataType=ftString then
showmessage('整形');
end;end.类型这么多 TFieldType = (ftUnknown, ftString, ftSmallint, ftInteger, ftWord, ftBoolean, ftFloat, ftCurrency, ftBCD, ftDate, ftTime, ftDateTime, ftBytes, ftVarBytes, ftAutoInc, ftBlob, ftMemo, ftGraphic, ftFmtMemo, ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftFixedChar, ftWideString, ftLargeint, ftADT, ftArray, ftReference, ftDataSet, ftOraBlob, ftOraClob, ftVariant, ftInterface, ftIDispatch, ftGuid, ftTimeStamp, ftFMTBcd);