如何获取列' TDbxReader 实例中的名称
我想使用 TDbxReader 实例制作报告,但找不到获取 aReader.value[index] 列名称的方法。有人可以帮助我吗?
aCmnd.Text := 'SELECT * FROM Country';
aCmnd.Prepare;
aReader := aCmnd.ExecuteQuery;
aColCount := aReader.ColumnCount;
Writeln( 'Results from Query: ' + aCmnd.Text );
// write column headers, but don´t know column names
for iColumn:= 0 to aColCount -1 do
Write(aReader.Value[iColumn].name + ' '); //would like unexistent name property
//How can I do something like this?
writeln;
while aReader.Next do
begin
for iColumn:= 0 to aColCount -1 do
Writeln( aReader.Value[iColumn].GetAnsiString + ' '); //assume string fields
end;
问候, 赫克托
I want to make a report with a TDbxReader instance but don't find the way to get the name of aReader.value[index] column. Somebody could help me?
aCmnd.Text := 'SELECT * FROM Country';
aCmnd.Prepare;
aReader := aCmnd.ExecuteQuery;
aColCount := aReader.ColumnCount;
Writeln( 'Results from Query: ' + aCmnd.Text );
// write column headers, but don´t know column names
for iColumn:= 0 to aColCount -1 do
Write(aReader.Value[iColumn].name + ' '); //would like unexistent name property
//How can I do something like this?
writeln;
while aReader.Next do
begin
for iColumn:= 0 to aColCount -1 do
Writeln( aReader.Value[iColumn].GetAnsiString + ' '); //assume string fields
end;
Regards,
Hector
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
找到了。使用了areder.dataType[index].name
Found it. Used areader.dataType[index].name