Solved

simple database question

Posted on 2006-11-21
1
190 Views
Last Modified: 2010-04-04
hi guys,

I have an ADO application with an MsAccess and I want to add the table fields name to a listbox... Any ideas?

best regards
Manuel Lopez (lopem)
0
Comment
Question by:lopem
1 Comment
 
LVL 15

Accepted Solution

by:
mikelittlewood earned 70 total points
ID: 17988726
procedure TForm1.Button1Click(Sender: TObject);
var
  slTemp: TStringList;
begin
  slTemp := TStringList.Create;
  try
    ADOQuery1.Open;
    ADOQuery1.GetFieldNames( slTemp);

    ListBox1.Items.Assign( slTemp);
  finally
    FreeAndNil( slTemp)
  end;
end;
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question